{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from scipy import stats\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "raw_data = pd.read_csv(\"C:/Users/Nicolas/Documents/Scraping/thecarconnection/raw_data_cleaning_all_may.csv\", index_col=0)\n",
    "imputed_data = raw_data.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MSRP                                          70\n",
       "Make                                           3\n",
       "Model                                          3\n",
       "Style Name                                     3\n",
       "Drivetrain                                     3\n",
       "Passenger Capacity                             3\n",
       "Passenger Doors                                3\n",
       "Body Style                                     5\n",
       "EPA Classification                         10990\n",
       "Front Shoulder Room (in)                    1335\n",
       "Front Head Room (in)                        1291\n",
       "Second Leg Room (in)                        4551\n",
       "Front Leg Room (in)                         1298\n",
       "Second Shoulder Room (in)                   4615\n",
       "Second Head Room (in)                       4531\n",
       "Height, Overall (in)                         211\n",
       "Wheelbase (in)                                53\n",
       "Width, Max w/o mirrors (in)                  151\n",
       "Fuel Tank Capacity, Approx (gal)             251\n",
       "EPA Fuel Economy Est - Hwy (MPG)            3748\n",
       "EPA Fuel Economy Est - City (MPG)           3744\n",
       "Fuel System                                  909\n",
       "Third Gear Ratio (:1)                       3301\n",
       "First Gear Ratio (:1)                       1872\n",
       "Fourth Gear Ratio (:1)                      3308\n",
       "Second Gear Ratio (:1)                      3296\n",
       "Front Brake Rotor Diam x Thickness (in)     2384\n",
       "Rear Brake Rotor Diam x Thickness (in)      5320\n",
       "Steering Type                                 58\n",
       "Turning Diameter - Curb to Curb             1579\n",
       "                                           ...  \n",
       "Basic Miles/km                                 4\n",
       "Basic Years                                    4\n",
       "Corrosion Miles/km                           481\n",
       "Corrosion Years                              481\n",
       "Drivetrain Miles/km                          139\n",
       "Drivetrain Years                             139\n",
       "Roadside Assistance Miles/km                4195\n",
       "Roadside Assistance Years                   4192\n",
       "Hybrid Engine                                  3\n",
       "Gears                                       2768\n",
       "Net Horsepower                                44\n",
       "Net Horsepower RPM                           337\n",
       "Net Torque                                   105\n",
       "Net Torque RPM                               463\n",
       "Cylinders                                    268\n",
       "Engine Configuration                         946\n",
       "Displacement (L)                             227\n",
       "Displacement (cc)                           1200\n",
       "Rear Tire Width                               40\n",
       "Front Tire Width                              39\n",
       "Rear Wheel Size                             3284\n",
       "Front Wheel Size                            3111\n",
       "Tire Rating                                   54\n",
       "Tire Width Ratio                              43\n",
       "Wheel Size Ratio                            3284\n",
       "Tire Ratio                                    46\n",
       "Year                                           3\n",
       "Country                                        3\n",
       "Country Code                                   3\n",
       "Category                                       5\n",
       "Length: 81, dtype: int64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "raw_data.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "col_to_delete = raw_data.columns[raw_data.isnull().sum() >= 0.2*len(raw_data)].tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "col_to_delete.remove('EPA Classification')\n",
    "col_to_delete"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "imputed_data = imputed_data.drop(col_to_delete, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# imputed_data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "specs_to_mean = ['Front Shoulder Room (in)',\n",
    "       'Front Head Room (in)', 'Second Leg Room (in)', 'Front Leg Room (in)',\n",
    "       'Second Shoulder Room (in)', 'Second Head Room (in)',\n",
    "       'Height, Overall (in)', 'Wheelbase (in)', 'Width, Max w/o mirrors (in)',\n",
    "       'Third Gear Ratio (:1)', 'First Gear Ratio (:1)',\n",
    "       'Fourth Gear Ratio (:1)', 'Second Gear Ratio (:1)',\n",
    "       'Turning Diameter - Curb to Curb']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Front Shoulder Room (in)</th>\n",
       "      <th>Front Head Room (in)</th>\n",
       "      <th>Second Leg Room (in)</th>\n",
       "      <th>Front Leg Room (in)</th>\n",
       "      <th>Second Shoulder Room (in)</th>\n",
       "      <th>Second Head Room (in)</th>\n",
       "      <th>Height, Overall (in)</th>\n",
       "      <th>Wheelbase (in)</th>\n",
       "      <th>Width, Max w/o mirrors (in)</th>\n",
       "      <th>Third Gear Ratio (:1)</th>\n",
       "      <th>First Gear Ratio (:1)</th>\n",
       "      <th>Fourth Gear Ratio (:1)</th>\n",
       "      <th>Second Gear Ratio (:1)</th>\n",
       "      <th>Turning Diameter - Curb to Curb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2017 Acura RDX FWD w/Technology/AcuraWatch Plus Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017 Acura RDX FWD w/Technology Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017 Acura RDX FWD w/Advance Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017 Acura RDX FWD w/AcuraWatch Plus</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017 Acura RDX FWD</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017 Acura RDX AWD w/Technology/AcuraWatch Plus Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017 Acura RDX AWD w/Technology Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017 Acura RDX AWD w/Advance Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017 Acura RDX AWD w/AcuraWatch Plus</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Acura RDX AWD</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Acura RDX FWD w/Technology/AcuraWatch Plus Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Acura RDX FWD w/Technology Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Acura RDX FWD w/Advance Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Acura RDX FWD w/AcuraWatch Plus</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Acura RDX FWD</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Acura RDX AWD w/Technology/AcuraWatch Plus Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Acura RDX AWD w/Technology Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Acura RDX AWD w/Advance Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Acura RDX AWD w/AcuraWatch Plus</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016 Acura RDX AWD 4-Door</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016 Acura RDX FWD 4-Door Tech Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016 Acura RDX FWD 4-Door Advance Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016 Acura RDX FWD 4-Door</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016 Acura RDX AWD 4-Door Tech Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016 Acura RDX AWD 4-Door Advance Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>65.0</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015 Acura RDX AWD 4-Door</th>\n",
       "      <td>58.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>38.3</td>\n",
       "      <td>42.0</td>\n",
       "      <td>57.2</td>\n",
       "      <td>38.1</td>\n",
       "      <td>66.1</td>\n",
       "      <td>105.7</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3.36</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2.09</td>\n",
       "      <td>38.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof/3rd</th>\n",
       "      <td>58.3</td>\n",
       "      <td>39.7</td>\n",
       "      <td>34.6</td>\n",
       "      <td>41.0</td>\n",
       "      <td>57.4</td>\n",
       "      <td>38.4</td>\n",
       "      <td>70.2</td>\n",
       "      <td>112.6</td>\n",
       "      <td>74.7</td>\n",
       "      <td>1.98</td>\n",
       "      <td>4.66</td>\n",
       "      <td>1.34</td>\n",
       "      <td>3.03</td>\n",
       "      <td>39.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof</th>\n",
       "      <td>58.3</td>\n",
       "      <td>39.7</td>\n",
       "      <td>36.4</td>\n",
       "      <td>41.0</td>\n",
       "      <td>57.8</td>\n",
       "      <td>38.9</td>\n",
       "      <td>70.2</td>\n",
       "      <td>112.6</td>\n",
       "      <td>74.7</td>\n",
       "      <td>1.98</td>\n",
       "      <td>4.66</td>\n",
       "      <td>1.34</td>\n",
       "      <td>3.03</td>\n",
       "      <td>39.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004 Volvo XC90 4-Door 2.5L Turbo AWD</th>\n",
       "      <td>58.3</td>\n",
       "      <td>40.1</td>\n",
       "      <td>36.4</td>\n",
       "      <td>41.0</td>\n",
       "      <td>57.8</td>\n",
       "      <td>39.5</td>\n",
       "      <td>70.2</td>\n",
       "      <td>112.6</td>\n",
       "      <td>74.7</td>\n",
       "      <td>1.98</td>\n",
       "      <td>4.66</td>\n",
       "      <td>1.34</td>\n",
       "      <td>3.03</td>\n",
       "      <td>39.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003 Volvo XC90 4-Door 2.5L Turbo</th>\n",
       "      <td>58.3</td>\n",
       "      <td>40.1</td>\n",
       "      <td>36.4</td>\n",
       "      <td>41.0</td>\n",
       "      <td>57.8</td>\n",
       "      <td>39.5</td>\n",
       "      <td>70.2</td>\n",
       "      <td>112.5</td>\n",
       "      <td>74.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD</th>\n",
       "      <td>58.3</td>\n",
       "      <td>39.7</td>\n",
       "      <td>36.4</td>\n",
       "      <td>41.0</td>\n",
       "      <td>57.8</td>\n",
       "      <td>38.9</td>\n",
       "      <td>70.2</td>\n",
       "      <td>112.5</td>\n",
       "      <td>74.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003 Volvo XC90 4-Door 2.5L Turbo AWD</th>\n",
       "      <td>58.3</td>\n",
       "      <td>40.1</td>\n",
       "      <td>36.4</td>\n",
       "      <td>41.0</td>\n",
       "      <td>57.8</td>\n",
       "      <td>39.5</td>\n",
       "      <td>70.2</td>\n",
       "      <td>112.5</td>\n",
       "      <td>74.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019 Volvo S90 T5 AWD Momentum</th>\n",
       "      <td>57.5</td>\n",
       "      <td>37.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.4</td>\n",
       "      <td>37.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>120.5</td>\n",
       "      <td>74.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum</th>\n",
       "      <td>57.5</td>\n",
       "      <td>37.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.4</td>\n",
       "      <td>37.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>120.5</td>\n",
       "      <td>74.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription</th>\n",
       "      <td>57.5</td>\n",
       "      <td>37.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.4</td>\n",
       "      <td>37.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>120.5</td>\n",
       "      <td>74.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019 Volvo S90 T6 AWD Momentum</th>\n",
       "      <td>57.5</td>\n",
       "      <td>37.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.4</td>\n",
       "      <td>37.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>120.5</td>\n",
       "      <td>74.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019 Volvo S90 T6 AWD Inscription</th>\n",
       "      <td>57.5</td>\n",
       "      <td>37.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.4</td>\n",
       "      <td>37.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>120.5</td>\n",
       "      <td>74.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019 Volvo S90 T5 FWD Momentum</th>\n",
       "      <td>57.5</td>\n",
       "      <td>37.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.4</td>\n",
       "      <td>37.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>120.5</td>\n",
       "      <td>74.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017 Volvo S90 T5 FWD Inscription</th>\n",
       "      <td>57.5</td>\n",
       "      <td>38.7</td>\n",
       "      <td>35.9</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.9</td>\n",
       "      <td>37.8</td>\n",
       "      <td>56.8</td>\n",
       "      <td>115.8</td>\n",
       "      <td>74.0</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>37.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017 Volvo S90 T6 AWD Momentum</th>\n",
       "      <td>57.5</td>\n",
       "      <td>38.7</td>\n",
       "      <td>35.9</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.9</td>\n",
       "      <td>37.8</td>\n",
       "      <td>56.8</td>\n",
       "      <td>115.8</td>\n",
       "      <td>74.0</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>37.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017 Volvo S90 T6 AWD Inscription</th>\n",
       "      <td>57.5</td>\n",
       "      <td>38.7</td>\n",
       "      <td>35.9</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.9</td>\n",
       "      <td>37.8</td>\n",
       "      <td>56.8</td>\n",
       "      <td>115.8</td>\n",
       "      <td>74.0</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>37.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017 Volvo S90 T5 FWD Momentum</th>\n",
       "      <td>57.5</td>\n",
       "      <td>38.7</td>\n",
       "      <td>35.9</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.9</td>\n",
       "      <td>37.8</td>\n",
       "      <td>56.8</td>\n",
       "      <td>115.8</td>\n",
       "      <td>74.0</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>37.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Volvo S90 T5 AWD Momentum</th>\n",
       "      <td>57.5</td>\n",
       "      <td>37.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.4</td>\n",
       "      <td>37.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>120.5</td>\n",
       "      <td>74.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum</th>\n",
       "      <td>57.5</td>\n",
       "      <td>37.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.4</td>\n",
       "      <td>37.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>120.5</td>\n",
       "      <td>74.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription</th>\n",
       "      <td>57.5</td>\n",
       "      <td>37.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.4</td>\n",
       "      <td>37.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>120.5</td>\n",
       "      <td>74.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Volvo S90 T6 AWD Momentum</th>\n",
       "      <td>57.5</td>\n",
       "      <td>37.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.4</td>\n",
       "      <td>37.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>120.5</td>\n",
       "      <td>74.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Volvo S90 T6 AWD Inscription</th>\n",
       "      <td>57.5</td>\n",
       "      <td>37.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.4</td>\n",
       "      <td>37.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>120.5</td>\n",
       "      <td>74.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Volvo S90 T5 FWD Momentum</th>\n",
       "      <td>57.5</td>\n",
       "      <td>37.8</td>\n",
       "      <td>40.4</td>\n",
       "      <td>42.2</td>\n",
       "      <td>55.4</td>\n",
       "      <td>37.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>120.5</td>\n",
       "      <td>74.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Volvo V60 Cross Country T5 AWD</th>\n",
       "      <td>57.0</td>\n",
       "      <td>38.7</td>\n",
       "      <td>33.5</td>\n",
       "      <td>41.9</td>\n",
       "      <td>55.2</td>\n",
       "      <td>37.6</td>\n",
       "      <td>60.8</td>\n",
       "      <td>109.2</td>\n",
       "      <td>73.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>37.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018 Volvo V60 Cross Country T5 AWD Platinum</th>\n",
       "      <td>57.0</td>\n",
       "      <td>38.7</td>\n",
       "      <td>33.5</td>\n",
       "      <td>41.9</td>\n",
       "      <td>55.2</td>\n",
       "      <td>37.6</td>\n",
       "      <td>60.8</td>\n",
       "      <td>109.2</td>\n",
       "      <td>73.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>37.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017 Volvo V60 Cross Country T5 AWD</th>\n",
       "      <td>57.0</td>\n",
       "      <td>38.7</td>\n",
       "      <td>33.5</td>\n",
       "      <td>41.9</td>\n",
       "      <td>55.2</td>\n",
       "      <td>37.6</td>\n",
       "      <td>60.8</td>\n",
       "      <td>109.2</td>\n",
       "      <td>73.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>37.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017 Volvo V60 Cross Country T5 AWD Platinum</th>\n",
       "      <td>57.0</td>\n",
       "      <td>38.7</td>\n",
       "      <td>33.5</td>\n",
       "      <td>41.9</td>\n",
       "      <td>55.2</td>\n",
       "      <td>37.6</td>\n",
       "      <td>60.8</td>\n",
       "      <td>109.2</td>\n",
       "      <td>73.4</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.03</td>\n",
       "      <td>37.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD</th>\n",
       "      <td>57.0</td>\n",
       "      <td>38.7</td>\n",
       "      <td>33.5</td>\n",
       "      <td>41.9</td>\n",
       "      <td>55.2</td>\n",
       "      <td>37.4</td>\n",
       "      <td>60.8</td>\n",
       "      <td>109.3</td>\n",
       "      <td>73.4</td>\n",
       "      <td>1.56</td>\n",
       "      <td>4.15</td>\n",
       "      <td>1.16</td>\n",
       "      <td>2.37</td>\n",
       "      <td>37.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016 Volvo V60 Cross Country 4-Door Wagon T5 Platinum AWD</th>\n",
       "      <td>57.0</td>\n",
       "      <td>38.7</td>\n",
       "      <td>33.5</td>\n",
       "      <td>41.9</td>\n",
       "      <td>55.2</td>\n",
       "      <td>37.4</td>\n",
       "      <td>60.8</td>\n",
       "      <td>109.3</td>\n",
       "      <td>73.4</td>\n",
       "      <td>1.56</td>\n",
       "      <td>4.15</td>\n",
       "      <td>1.16</td>\n",
       "      <td>2.37</td>\n",
       "      <td>37.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015 Volvo V60 Cross Country 2015.5 4-Door Wagon T5 AWD</th>\n",
       "      <td>57.0</td>\n",
       "      <td>38.7</td>\n",
       "      <td>33.5</td>\n",
       "      <td>41.9</td>\n",
       "      <td>55.2</td>\n",
       "      <td>37.4</td>\n",
       "      <td>58.4</td>\n",
       "      <td>109.3</td>\n",
       "      <td>73.4</td>\n",
       "      <td>1.56</td>\n",
       "      <td>4.15</td>\n",
       "      <td>1.16</td>\n",
       "      <td>2.37</td>\n",
       "      <td>37.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015 Volvo V60 Cross Country 2015.5 4-Door Wagon T5 Platinum AWD</th>\n",
       "      <td>57.0</td>\n",
       "      <td>38.7</td>\n",
       "      <td>33.5</td>\n",
       "      <td>41.9</td>\n",
       "      <td>55.2</td>\n",
       "      <td>37.4</td>\n",
       "      <td>58.4</td>\n",
       "      <td>109.3</td>\n",
       "      <td>73.4</td>\n",
       "      <td>1.56</td>\n",
       "      <td>4.15</td>\n",
       "      <td>1.16</td>\n",
       "      <td>2.37</td>\n",
       "      <td>37.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>31738 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    Front Shoulder Room (in)  \\\n",
       "2017 Acura RDX FWD w/Technology/AcuraWatch Plus...                      58.7   \n",
       "2017 Acura RDX FWD w/Technology Pkg                                     58.7   \n",
       "2017 Acura RDX FWD w/Advance Pkg                                        58.7   \n",
       "2017 Acura RDX FWD w/AcuraWatch Plus                                    58.7   \n",
       "2017 Acura RDX FWD                                                      58.7   \n",
       "2017 Acura RDX AWD w/Technology/AcuraWatch Plus...                      58.7   \n",
       "2017 Acura RDX AWD w/Technology Pkg                                     58.7   \n",
       "2017 Acura RDX AWD w/Advance Pkg                                        58.7   \n",
       "2017 Acura RDX AWD w/AcuraWatch Plus                                    58.7   \n",
       "2018 Acura RDX AWD                                                      58.7   \n",
       "2018 Acura RDX FWD w/Technology/AcuraWatch Plus...                      58.7   \n",
       "2018 Acura RDX FWD w/Technology Pkg                                     58.7   \n",
       "2018 Acura RDX FWD w/Advance Pkg                                        58.7   \n",
       "2018 Acura RDX FWD w/AcuraWatch Plus                                    58.7   \n",
       "2018 Acura RDX FWD                                                      58.7   \n",
       "2018 Acura RDX AWD w/Technology/AcuraWatch Plus...                      58.7   \n",
       "2018 Acura RDX AWD w/Technology Pkg                                     58.7   \n",
       "2018 Acura RDX AWD w/Advance Pkg                                        58.7   \n",
       "2018 Acura RDX AWD w/AcuraWatch Plus                                    58.7   \n",
       "2016 Acura RDX AWD 4-Door                                               58.7   \n",
       "2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg                      58.7   \n",
       "2016 Acura RDX FWD 4-Door Tech Pkg                                      58.7   \n",
       "2016 Acura RDX FWD 4-Door Advance Pkg                                   58.7   \n",
       "2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg                           58.7   \n",
       "2016 Acura RDX FWD 4-Door                                               58.7   \n",
       "2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg                      58.7   \n",
       "2016 Acura RDX AWD 4-Door Tech Pkg                                      58.7   \n",
       "2016 Acura RDX AWD 4-Door Advance Pkg                                   58.7   \n",
       "2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg                           58.7   \n",
       "2015 Acura RDX AWD 4-Door                                               58.7   \n",
       "...                                                                      ...   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof...                      58.3   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof                         58.3   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD                                   58.3   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo                                       58.3   \n",
       "2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD                              58.3   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo AWD                                   58.3   \n",
       "2019 Volvo S90 T5 AWD Momentum                                          57.5   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                          57.5   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                       57.5   \n",
       "2019 Volvo S90 T6 AWD Momentum                                          57.5   \n",
       "2019 Volvo S90 T6 AWD Inscription                                       57.5   \n",
       "2019 Volvo S90 T5 FWD Momentum                                          57.5   \n",
       "2017 Volvo S90 T5 FWD Inscription                                       57.5   \n",
       "2017 Volvo S90 T6 AWD Momentum                                          57.5   \n",
       "2017 Volvo S90 T6 AWD Inscription                                       57.5   \n",
       "2017 Volvo S90 T5 FWD Momentum                                          57.5   \n",
       "2018 Volvo S90 T5 AWD Momentum                                          57.5   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                          57.5   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                       57.5   \n",
       "2018 Volvo S90 T6 AWD Momentum                                          57.5   \n",
       "2018 Volvo S90 T6 AWD Inscription                                       57.5   \n",
       "2018 Volvo S90 T5 FWD Momentum                                          57.5   \n",
       "2018 Volvo V60 Cross Country T5 AWD                                     57.0   \n",
       "2018 Volvo V60 Cross Country T5 AWD Platinum                            57.0   \n",
       "2017 Volvo V60 Cross Country T5 AWD                                     57.0   \n",
       "2017 Volvo V60 Cross Country T5 AWD Platinum                            57.0   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD                        57.0   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 Pl...                      57.0   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                      57.0   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                      57.0   \n",
       "\n",
       "                                                    Front Head Room (in)  \\\n",
       "2017 Acura RDX FWD w/Technology/AcuraWatch Plus...                  38.7   \n",
       "2017 Acura RDX FWD w/Technology Pkg                                 38.7   \n",
       "2017 Acura RDX FWD w/Advance Pkg                                    38.7   \n",
       "2017 Acura RDX FWD w/AcuraWatch Plus                                38.7   \n",
       "2017 Acura RDX FWD                                                  38.7   \n",
       "2017 Acura RDX AWD w/Technology/AcuraWatch Plus...                  38.7   \n",
       "2017 Acura RDX AWD w/Technology Pkg                                 38.7   \n",
       "2017 Acura RDX AWD w/Advance Pkg                                    38.7   \n",
       "2017 Acura RDX AWD w/AcuraWatch Plus                                38.7   \n",
       "2018 Acura RDX AWD                                                  38.7   \n",
       "2018 Acura RDX FWD w/Technology/AcuraWatch Plus...                  38.7   \n",
       "2018 Acura RDX FWD w/Technology Pkg                                 38.7   \n",
       "2018 Acura RDX FWD w/Advance Pkg                                    38.7   \n",
       "2018 Acura RDX FWD w/AcuraWatch Plus                                38.7   \n",
       "2018 Acura RDX FWD                                                  38.7   \n",
       "2018 Acura RDX AWD w/Technology/AcuraWatch Plus...                  38.7   \n",
       "2018 Acura RDX AWD w/Technology Pkg                                 38.7   \n",
       "2018 Acura RDX AWD w/Advance Pkg                                    38.7   \n",
       "2018 Acura RDX AWD w/AcuraWatch Plus                                38.7   \n",
       "2016 Acura RDX AWD 4-Door                                           38.7   \n",
       "2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg                  38.7   \n",
       "2016 Acura RDX FWD 4-Door Tech Pkg                                  38.7   \n",
       "2016 Acura RDX FWD 4-Door Advance Pkg                               38.7   \n",
       "2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg                       38.7   \n",
       "2016 Acura RDX FWD 4-Door                                           38.7   \n",
       "2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg                  38.7   \n",
       "2016 Acura RDX AWD 4-Door Tech Pkg                                  38.7   \n",
       "2016 Acura RDX AWD 4-Door Advance Pkg                               38.7   \n",
       "2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg                       38.7   \n",
       "2015 Acura RDX AWD 4-Door                                           38.7   \n",
       "...                                                                  ...   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof...                  39.7   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof                     39.7   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD                               40.1   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo                                   40.1   \n",
       "2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD                          39.7   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo AWD                               40.1   \n",
       "2019 Volvo S90 T5 AWD Momentum                                      37.8   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                      37.8   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                   37.8   \n",
       "2019 Volvo S90 T6 AWD Momentum                                      37.8   \n",
       "2019 Volvo S90 T6 AWD Inscription                                   37.8   \n",
       "2019 Volvo S90 T5 FWD Momentum                                      37.8   \n",
       "2017 Volvo S90 T5 FWD Inscription                                   38.7   \n",
       "2017 Volvo S90 T6 AWD Momentum                                      38.7   \n",
       "2017 Volvo S90 T6 AWD Inscription                                   38.7   \n",
       "2017 Volvo S90 T5 FWD Momentum                                      38.7   \n",
       "2018 Volvo S90 T5 AWD Momentum                                      37.8   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                      37.8   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                   37.8   \n",
       "2018 Volvo S90 T6 AWD Momentum                                      37.8   \n",
       "2018 Volvo S90 T6 AWD Inscription                                   37.8   \n",
       "2018 Volvo S90 T5 FWD Momentum                                      37.8   \n",
       "2018 Volvo V60 Cross Country T5 AWD                                 38.7   \n",
       "2018 Volvo V60 Cross Country T5 AWD Platinum                        38.7   \n",
       "2017 Volvo V60 Cross Country T5 AWD                                 38.7   \n",
       "2017 Volvo V60 Cross Country T5 AWD Platinum                        38.7   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD                    38.7   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 Pl...                  38.7   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                  38.7   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                  38.7   \n",
       "\n",
       "                                                    Second Leg Room (in)  \\\n",
       "2017 Acura RDX FWD w/Technology/AcuraWatch Plus...                  38.3   \n",
       "2017 Acura RDX FWD w/Technology Pkg                                 38.3   \n",
       "2017 Acura RDX FWD w/Advance Pkg                                    38.3   \n",
       "2017 Acura RDX FWD w/AcuraWatch Plus                                38.3   \n",
       "2017 Acura RDX FWD                                                  38.3   \n",
       "2017 Acura RDX AWD w/Technology/AcuraWatch Plus...                  38.3   \n",
       "2017 Acura RDX AWD w/Technology Pkg                                 38.3   \n",
       "2017 Acura RDX AWD w/Advance Pkg                                    38.3   \n",
       "2017 Acura RDX AWD w/AcuraWatch Plus                                38.3   \n",
       "2018 Acura RDX AWD                                                  38.3   \n",
       "2018 Acura RDX FWD w/Technology/AcuraWatch Plus...                  38.3   \n",
       "2018 Acura RDX FWD w/Technology Pkg                                 38.3   \n",
       "2018 Acura RDX FWD w/Advance Pkg                                    38.3   \n",
       "2018 Acura RDX FWD w/AcuraWatch Plus                                38.3   \n",
       "2018 Acura RDX FWD                                                  38.3   \n",
       "2018 Acura RDX AWD w/Technology/AcuraWatch Plus...                  38.3   \n",
       "2018 Acura RDX AWD w/Technology Pkg                                 38.3   \n",
       "2018 Acura RDX AWD w/Advance Pkg                                    38.3   \n",
       "2018 Acura RDX AWD w/AcuraWatch Plus                                38.3   \n",
       "2016 Acura RDX AWD 4-Door                                           38.3   \n",
       "2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg                  38.3   \n",
       "2016 Acura RDX FWD 4-Door Tech Pkg                                  38.3   \n",
       "2016 Acura RDX FWD 4-Door Advance Pkg                               38.3   \n",
       "2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg                       38.3   \n",
       "2016 Acura RDX FWD 4-Door                                           38.3   \n",
       "2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg                  38.3   \n",
       "2016 Acura RDX AWD 4-Door Tech Pkg                                  38.3   \n",
       "2016 Acura RDX AWD 4-Door Advance Pkg                               38.3   \n",
       "2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg                       38.3   \n",
       "2015 Acura RDX AWD 4-Door                                           38.3   \n",
       "...                                                                  ...   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof...                  34.6   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof                     36.4   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD                               36.4   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo                                   36.4   \n",
       "2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD                          36.4   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo AWD                               36.4   \n",
       "2019 Volvo S90 T5 AWD Momentum                                      40.4   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                      40.4   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                   40.4   \n",
       "2019 Volvo S90 T6 AWD Momentum                                      40.4   \n",
       "2019 Volvo S90 T6 AWD Inscription                                   40.4   \n",
       "2019 Volvo S90 T5 FWD Momentum                                      40.4   \n",
       "2017 Volvo S90 T5 FWD Inscription                                   35.9   \n",
       "2017 Volvo S90 T6 AWD Momentum                                      35.9   \n",
       "2017 Volvo S90 T6 AWD Inscription                                   35.9   \n",
       "2017 Volvo S90 T5 FWD Momentum                                      35.9   \n",
       "2018 Volvo S90 T5 AWD Momentum                                      40.4   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                      40.4   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                   40.4   \n",
       "2018 Volvo S90 T6 AWD Momentum                                      40.4   \n",
       "2018 Volvo S90 T6 AWD Inscription                                   40.4   \n",
       "2018 Volvo S90 T5 FWD Momentum                                      40.4   \n",
       "2018 Volvo V60 Cross Country T5 AWD                                 33.5   \n",
       "2018 Volvo V60 Cross Country T5 AWD Platinum                        33.5   \n",
       "2017 Volvo V60 Cross Country T5 AWD                                 33.5   \n",
       "2017 Volvo V60 Cross Country T5 AWD Platinum                        33.5   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD                    33.5   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 Pl...                  33.5   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                  33.5   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                  33.5   \n",
       "\n",
       "                                                    Front Leg Room (in)  \\\n",
       "2017 Acura RDX FWD w/Technology/AcuraWatch Plus...                 42.0   \n",
       "2017 Acura RDX FWD w/Technology Pkg                                42.0   \n",
       "2017 Acura RDX FWD w/Advance Pkg                                   42.0   \n",
       "2017 Acura RDX FWD w/AcuraWatch Plus                               42.0   \n",
       "2017 Acura RDX FWD                                                 42.0   \n",
       "2017 Acura RDX AWD w/Technology/AcuraWatch Plus...                 42.0   \n",
       "2017 Acura RDX AWD w/Technology Pkg                                42.0   \n",
       "2017 Acura RDX AWD w/Advance Pkg                                   42.0   \n",
       "2017 Acura RDX AWD w/AcuraWatch Plus                               42.0   \n",
       "2018 Acura RDX AWD                                                 42.0   \n",
       "2018 Acura RDX FWD w/Technology/AcuraWatch Plus...                 42.0   \n",
       "2018 Acura RDX FWD w/Technology Pkg                                42.0   \n",
       "2018 Acura RDX FWD w/Advance Pkg                                   42.0   \n",
       "2018 Acura RDX FWD w/AcuraWatch Plus                               42.0   \n",
       "2018 Acura RDX FWD                                                 42.0   \n",
       "2018 Acura RDX AWD w/Technology/AcuraWatch Plus...                 42.0   \n",
       "2018 Acura RDX AWD w/Technology Pkg                                42.0   \n",
       "2018 Acura RDX AWD w/Advance Pkg                                   42.0   \n",
       "2018 Acura RDX AWD w/AcuraWatch Plus                               42.0   \n",
       "2016 Acura RDX AWD 4-Door                                          42.0   \n",
       "2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg                 42.0   \n",
       "2016 Acura RDX FWD 4-Door Tech Pkg                                 42.0   \n",
       "2016 Acura RDX FWD 4-Door Advance Pkg                              42.0   \n",
       "2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg                      42.0   \n",
       "2016 Acura RDX FWD 4-Door                                          42.0   \n",
       "2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg                 42.0   \n",
       "2016 Acura RDX AWD 4-Door Tech Pkg                                 42.0   \n",
       "2016 Acura RDX AWD 4-Door Advance Pkg                              42.0   \n",
       "2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg                      42.0   \n",
       "2015 Acura RDX AWD 4-Door                                          42.0   \n",
       "...                                                                 ...   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof...                 41.0   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof                    41.0   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD                              41.0   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo                                  41.0   \n",
       "2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD                         41.0   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo AWD                              41.0   \n",
       "2019 Volvo S90 T5 AWD Momentum                                     42.2   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                     42.2   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                  42.2   \n",
       "2019 Volvo S90 T6 AWD Momentum                                     42.2   \n",
       "2019 Volvo S90 T6 AWD Inscription                                  42.2   \n",
       "2019 Volvo S90 T5 FWD Momentum                                     42.2   \n",
       "2017 Volvo S90 T5 FWD Inscription                                  42.2   \n",
       "2017 Volvo S90 T6 AWD Momentum                                     42.2   \n",
       "2017 Volvo S90 T6 AWD Inscription                                  42.2   \n",
       "2017 Volvo S90 T5 FWD Momentum                                     42.2   \n",
       "2018 Volvo S90 T5 AWD Momentum                                     42.2   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                     42.2   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                  42.2   \n",
       "2018 Volvo S90 T6 AWD Momentum                                     42.2   \n",
       "2018 Volvo S90 T6 AWD Inscription                                  42.2   \n",
       "2018 Volvo S90 T5 FWD Momentum                                     42.2   \n",
       "2018 Volvo V60 Cross Country T5 AWD                                41.9   \n",
       "2018 Volvo V60 Cross Country T5 AWD Platinum                       41.9   \n",
       "2017 Volvo V60 Cross Country T5 AWD                                41.9   \n",
       "2017 Volvo V60 Cross Country T5 AWD Platinum                       41.9   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD                   41.9   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 Pl...                 41.9   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                 41.9   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                 41.9   \n",
       "\n",
       "                                                    Second Shoulder Room (in)  \\\n",
       "2017 Acura RDX FWD w/Technology/AcuraWatch Plus...                       57.2   \n",
       "2017 Acura RDX FWD w/Technology Pkg                                      57.2   \n",
       "2017 Acura RDX FWD w/Advance Pkg                                         57.2   \n",
       "2017 Acura RDX FWD w/AcuraWatch Plus                                     57.2   \n",
       "2017 Acura RDX FWD                                                       57.2   \n",
       "2017 Acura RDX AWD w/Technology/AcuraWatch Plus...                       57.2   \n",
       "2017 Acura RDX AWD w/Technology Pkg                                      57.2   \n",
       "2017 Acura RDX AWD w/Advance Pkg                                         57.2   \n",
       "2017 Acura RDX AWD w/AcuraWatch Plus                                     57.2   \n",
       "2018 Acura RDX AWD                                                       57.2   \n",
       "2018 Acura RDX FWD w/Technology/AcuraWatch Plus...                       57.2   \n",
       "2018 Acura RDX FWD w/Technology Pkg                                      57.2   \n",
       "2018 Acura RDX FWD w/Advance Pkg                                         57.2   \n",
       "2018 Acura RDX FWD w/AcuraWatch Plus                                     57.2   \n",
       "2018 Acura RDX FWD                                                       57.2   \n",
       "2018 Acura RDX AWD w/Technology/AcuraWatch Plus...                       57.2   \n",
       "2018 Acura RDX AWD w/Technology Pkg                                      57.2   \n",
       "2018 Acura RDX AWD w/Advance Pkg                                         57.2   \n",
       "2018 Acura RDX AWD w/AcuraWatch Plus                                     57.2   \n",
       "2016 Acura RDX AWD 4-Door                                                57.2   \n",
       "2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg                       57.2   \n",
       "2016 Acura RDX FWD 4-Door Tech Pkg                                       57.2   \n",
       "2016 Acura RDX FWD 4-Door Advance Pkg                                    57.2   \n",
       "2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg                            57.2   \n",
       "2016 Acura RDX FWD 4-Door                                                57.2   \n",
       "2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg                       57.2   \n",
       "2016 Acura RDX AWD 4-Door Tech Pkg                                       57.2   \n",
       "2016 Acura RDX AWD 4-Door Advance Pkg                                    57.2   \n",
       "2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg                            57.2   \n",
       "2015 Acura RDX AWD 4-Door                                                57.2   \n",
       "...                                                                       ...   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof...                       57.4   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof                          57.8   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD                                    57.8   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo                                        57.8   \n",
       "2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD                               57.8   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo AWD                                    57.8   \n",
       "2019 Volvo S90 T5 AWD Momentum                                           55.4   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                           55.4   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                        55.4   \n",
       "2019 Volvo S90 T6 AWD Momentum                                           55.4   \n",
       "2019 Volvo S90 T6 AWD Inscription                                        55.4   \n",
       "2019 Volvo S90 T5 FWD Momentum                                           55.4   \n",
       "2017 Volvo S90 T5 FWD Inscription                                        55.9   \n",
       "2017 Volvo S90 T6 AWD Momentum                                           55.9   \n",
       "2017 Volvo S90 T6 AWD Inscription                                        55.9   \n",
       "2017 Volvo S90 T5 FWD Momentum                                           55.9   \n",
       "2018 Volvo S90 T5 AWD Momentum                                           55.4   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                           55.4   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                        55.4   \n",
       "2018 Volvo S90 T6 AWD Momentum                                           55.4   \n",
       "2018 Volvo S90 T6 AWD Inscription                                        55.4   \n",
       "2018 Volvo S90 T5 FWD Momentum                                           55.4   \n",
       "2018 Volvo V60 Cross Country T5 AWD                                      55.2   \n",
       "2018 Volvo V60 Cross Country T5 AWD Platinum                             55.2   \n",
       "2017 Volvo V60 Cross Country T5 AWD                                      55.2   \n",
       "2017 Volvo V60 Cross Country T5 AWD Platinum                             55.2   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD                         55.2   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 Pl...                       55.2   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                       55.2   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                       55.2   \n",
       "\n",
       "                                                    Second Head Room (in)  \\\n",
       "2017 Acura RDX FWD w/Technology/AcuraWatch Plus...                   38.1   \n",
       "2017 Acura RDX FWD w/Technology Pkg                                  38.1   \n",
       "2017 Acura RDX FWD w/Advance Pkg                                     38.1   \n",
       "2017 Acura RDX FWD w/AcuraWatch Plus                                 38.1   \n",
       "2017 Acura RDX FWD                                                   38.1   \n",
       "2017 Acura RDX AWD w/Technology/AcuraWatch Plus...                   38.1   \n",
       "2017 Acura RDX AWD w/Technology Pkg                                  38.1   \n",
       "2017 Acura RDX AWD w/Advance Pkg                                     38.1   \n",
       "2017 Acura RDX AWD w/AcuraWatch Plus                                 38.1   \n",
       "2018 Acura RDX AWD                                                   38.1   \n",
       "2018 Acura RDX FWD w/Technology/AcuraWatch Plus...                   38.1   \n",
       "2018 Acura RDX FWD w/Technology Pkg                                  38.1   \n",
       "2018 Acura RDX FWD w/Advance Pkg                                     38.1   \n",
       "2018 Acura RDX FWD w/AcuraWatch Plus                                 38.1   \n",
       "2018 Acura RDX FWD                                                   38.1   \n",
       "2018 Acura RDX AWD w/Technology/AcuraWatch Plus...                   38.1   \n",
       "2018 Acura RDX AWD w/Technology Pkg                                  38.1   \n",
       "2018 Acura RDX AWD w/Advance Pkg                                     38.1   \n",
       "2018 Acura RDX AWD w/AcuraWatch Plus                                 38.1   \n",
       "2016 Acura RDX AWD 4-Door                                            38.1   \n",
       "2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg                   38.1   \n",
       "2016 Acura RDX FWD 4-Door Tech Pkg                                   38.1   \n",
       "2016 Acura RDX FWD 4-Door Advance Pkg                                38.1   \n",
       "2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg                        38.1   \n",
       "2016 Acura RDX FWD 4-Door                                            38.1   \n",
       "2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg                   38.1   \n",
       "2016 Acura RDX AWD 4-Door Tech Pkg                                   38.1   \n",
       "2016 Acura RDX AWD 4-Door Advance Pkg                                38.1   \n",
       "2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg                        38.1   \n",
       "2015 Acura RDX AWD 4-Door                                            38.1   \n",
       "...                                                                   ...   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof...                   38.4   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof                      38.9   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD                                39.5   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo                                    39.5   \n",
       "2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD                           38.9   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo AWD                                39.5   \n",
       "2019 Volvo S90 T5 AWD Momentum                                       37.8   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                       37.8   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                    37.8   \n",
       "2019 Volvo S90 T6 AWD Momentum                                       37.8   \n",
       "2019 Volvo S90 T6 AWD Inscription                                    37.8   \n",
       "2019 Volvo S90 T5 FWD Momentum                                       37.8   \n",
       "2017 Volvo S90 T5 FWD Inscription                                    37.8   \n",
       "2017 Volvo S90 T6 AWD Momentum                                       37.8   \n",
       "2017 Volvo S90 T6 AWD Inscription                                    37.8   \n",
       "2017 Volvo S90 T5 FWD Momentum                                       37.8   \n",
       "2018 Volvo S90 T5 AWD Momentum                                       37.8   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                       37.8   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                    37.8   \n",
       "2018 Volvo S90 T6 AWD Momentum                                       37.8   \n",
       "2018 Volvo S90 T6 AWD Inscription                                    37.8   \n",
       "2018 Volvo S90 T5 FWD Momentum                                       37.8   \n",
       "2018 Volvo V60 Cross Country T5 AWD                                  37.6   \n",
       "2018 Volvo V60 Cross Country T5 AWD Platinum                         37.6   \n",
       "2017 Volvo V60 Cross Country T5 AWD                                  37.6   \n",
       "2017 Volvo V60 Cross Country T5 AWD Platinum                         37.6   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD                     37.4   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 Pl...                   37.4   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                   37.4   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                   37.4   \n",
       "\n",
       "                                                    Height, Overall (in)  \\\n",
       "2017 Acura RDX FWD w/Technology/AcuraWatch Plus...                  65.0   \n",
       "2017 Acura RDX FWD w/Technology Pkg                                 65.0   \n",
       "2017 Acura RDX FWD w/Advance Pkg                                    65.0   \n",
       "2017 Acura RDX FWD w/AcuraWatch Plus                                65.0   \n",
       "2017 Acura RDX FWD                                                  65.0   \n",
       "2017 Acura RDX AWD w/Technology/AcuraWatch Plus...                  65.0   \n",
       "2017 Acura RDX AWD w/Technology Pkg                                 65.0   \n",
       "2017 Acura RDX AWD w/Advance Pkg                                    65.0   \n",
       "2017 Acura RDX AWD w/AcuraWatch Plus                                65.0   \n",
       "2018 Acura RDX AWD                                                  65.0   \n",
       "2018 Acura RDX FWD w/Technology/AcuraWatch Plus...                  65.0   \n",
       "2018 Acura RDX FWD w/Technology Pkg                                 65.0   \n",
       "2018 Acura RDX FWD w/Advance Pkg                                    65.0   \n",
       "2018 Acura RDX FWD w/AcuraWatch Plus                                65.0   \n",
       "2018 Acura RDX FWD                                                  65.0   \n",
       "2018 Acura RDX AWD w/Technology/AcuraWatch Plus...                  65.0   \n",
       "2018 Acura RDX AWD w/Technology Pkg                                 65.0   \n",
       "2018 Acura RDX AWD w/Advance Pkg                                    65.0   \n",
       "2018 Acura RDX AWD w/AcuraWatch Plus                                65.0   \n",
       "2016 Acura RDX AWD 4-Door                                           65.0   \n",
       "2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg                  65.0   \n",
       "2016 Acura RDX FWD 4-Door Tech Pkg                                  65.0   \n",
       "2016 Acura RDX FWD 4-Door Advance Pkg                               65.0   \n",
       "2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg                       65.0   \n",
       "2016 Acura RDX FWD 4-Door                                           65.0   \n",
       "2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg                  65.0   \n",
       "2016 Acura RDX AWD 4-Door Tech Pkg                                  65.0   \n",
       "2016 Acura RDX AWD 4-Door Advance Pkg                               65.0   \n",
       "2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg                       65.0   \n",
       "2015 Acura RDX AWD 4-Door                                           66.1   \n",
       "...                                                                  ...   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof...                  70.2   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof                     70.2   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD                               70.2   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo                                   70.2   \n",
       "2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD                          70.2   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo AWD                               70.2   \n",
       "2019 Volvo S90 T5 AWD Momentum                                      57.1   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                      57.1   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                   57.1   \n",
       "2019 Volvo S90 T6 AWD Momentum                                      57.1   \n",
       "2019 Volvo S90 T6 AWD Inscription                                   57.1   \n",
       "2019 Volvo S90 T5 FWD Momentum                                      57.1   \n",
       "2017 Volvo S90 T5 FWD Inscription                                   56.8   \n",
       "2017 Volvo S90 T6 AWD Momentum                                      56.8   \n",
       "2017 Volvo S90 T6 AWD Inscription                                   56.8   \n",
       "2017 Volvo S90 T5 FWD Momentum                                      56.8   \n",
       "2018 Volvo S90 T5 AWD Momentum                                      57.1   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                      57.1   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                   57.1   \n",
       "2018 Volvo S90 T6 AWD Momentum                                      57.1   \n",
       "2018 Volvo S90 T6 AWD Inscription                                   57.1   \n",
       "2018 Volvo S90 T5 FWD Momentum                                      57.1   \n",
       "2018 Volvo V60 Cross Country T5 AWD                                 60.8   \n",
       "2018 Volvo V60 Cross Country T5 AWD Platinum                        60.8   \n",
       "2017 Volvo V60 Cross Country T5 AWD                                 60.8   \n",
       "2017 Volvo V60 Cross Country T5 AWD Platinum                        60.8   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD                    60.8   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 Pl...                  60.8   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                  58.4   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                  58.4   \n",
       "\n",
       "                                                    Wheelbase (in)  \\\n",
       "2017 Acura RDX FWD w/Technology/AcuraWatch Plus...           105.7   \n",
       "2017 Acura RDX FWD w/Technology Pkg                          105.7   \n",
       "2017 Acura RDX FWD w/Advance Pkg                             105.7   \n",
       "2017 Acura RDX FWD w/AcuraWatch Plus                         105.7   \n",
       "2017 Acura RDX FWD                                           105.7   \n",
       "2017 Acura RDX AWD w/Technology/AcuraWatch Plus...           105.7   \n",
       "2017 Acura RDX AWD w/Technology Pkg                          105.7   \n",
       "2017 Acura RDX AWD w/Advance Pkg                             105.7   \n",
       "2017 Acura RDX AWD w/AcuraWatch Plus                         105.7   \n",
       "2018 Acura RDX AWD                                           105.7   \n",
       "2018 Acura RDX FWD w/Technology/AcuraWatch Plus...           105.7   \n",
       "2018 Acura RDX FWD w/Technology Pkg                          105.7   \n",
       "2018 Acura RDX FWD w/Advance Pkg                             105.7   \n",
       "2018 Acura RDX FWD w/AcuraWatch Plus                         105.7   \n",
       "2018 Acura RDX FWD                                           105.7   \n",
       "2018 Acura RDX AWD w/Technology/AcuraWatch Plus...           105.7   \n",
       "2018 Acura RDX AWD w/Technology Pkg                          105.7   \n",
       "2018 Acura RDX AWD w/Advance Pkg                             105.7   \n",
       "2018 Acura RDX AWD w/AcuraWatch Plus                         105.7   \n",
       "2016 Acura RDX AWD 4-Door                                    105.7   \n",
       "2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg           105.7   \n",
       "2016 Acura RDX FWD 4-Door Tech Pkg                           105.7   \n",
       "2016 Acura RDX FWD 4-Door Advance Pkg                        105.7   \n",
       "2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg                105.7   \n",
       "2016 Acura RDX FWD 4-Door                                    105.7   \n",
       "2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg           105.7   \n",
       "2016 Acura RDX AWD 4-Door Tech Pkg                           105.7   \n",
       "2016 Acura RDX AWD 4-Door Advance Pkg                        105.7   \n",
       "2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg                105.7   \n",
       "2015 Acura RDX AWD 4-Door                                    105.7   \n",
       "...                                                            ...   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof...           112.6   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof              112.6   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD                        112.6   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo                            112.5   \n",
       "2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD                   112.5   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo AWD                        112.5   \n",
       "2019 Volvo S90 T5 AWD Momentum                               120.5   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum               120.5   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription            120.5   \n",
       "2019 Volvo S90 T6 AWD Momentum                               120.5   \n",
       "2019 Volvo S90 T6 AWD Inscription                            120.5   \n",
       "2019 Volvo S90 T5 FWD Momentum                               120.5   \n",
       "2017 Volvo S90 T5 FWD Inscription                            115.8   \n",
       "2017 Volvo S90 T6 AWD Momentum                               115.8   \n",
       "2017 Volvo S90 T6 AWD Inscription                            115.8   \n",
       "2017 Volvo S90 T5 FWD Momentum                               115.8   \n",
       "2018 Volvo S90 T5 AWD Momentum                               120.5   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum               120.5   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription            120.5   \n",
       "2018 Volvo S90 T6 AWD Momentum                               120.5   \n",
       "2018 Volvo S90 T6 AWD Inscription                            120.5   \n",
       "2018 Volvo S90 T5 FWD Momentum                               120.5   \n",
       "2018 Volvo V60 Cross Country T5 AWD                          109.2   \n",
       "2018 Volvo V60 Cross Country T5 AWD Platinum                 109.2   \n",
       "2017 Volvo V60 Cross Country T5 AWD                          109.2   \n",
       "2017 Volvo V60 Cross Country T5 AWD Platinum                 109.2   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD             109.3   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 Pl...           109.3   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...           109.3   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...           109.3   \n",
       "\n",
       "                                                    Width, Max w/o mirrors (in)  \\\n",
       "2017 Acura RDX FWD w/Technology/AcuraWatch Plus...                         73.7   \n",
       "2017 Acura RDX FWD w/Technology Pkg                                        73.7   \n",
       "2017 Acura RDX FWD w/Advance Pkg                                           73.7   \n",
       "2017 Acura RDX FWD w/AcuraWatch Plus                                       73.7   \n",
       "2017 Acura RDX FWD                                                         73.7   \n",
       "2017 Acura RDX AWD w/Technology/AcuraWatch Plus...                         73.7   \n",
       "2017 Acura RDX AWD w/Technology Pkg                                        73.7   \n",
       "2017 Acura RDX AWD w/Advance Pkg                                           73.7   \n",
       "2017 Acura RDX AWD w/AcuraWatch Plus                                       73.7   \n",
       "2018 Acura RDX AWD                                                         73.7   \n",
       "2018 Acura RDX FWD w/Technology/AcuraWatch Plus...                         73.7   \n",
       "2018 Acura RDX FWD w/Technology Pkg                                        73.7   \n",
       "2018 Acura RDX FWD w/Advance Pkg                                           73.7   \n",
       "2018 Acura RDX FWD w/AcuraWatch Plus                                       73.7   \n",
       "2018 Acura RDX FWD                                                         73.7   \n",
       "2018 Acura RDX AWD w/Technology/AcuraWatch Plus...                         73.7   \n",
       "2018 Acura RDX AWD w/Technology Pkg                                        73.7   \n",
       "2018 Acura RDX AWD w/Advance Pkg                                           73.7   \n",
       "2018 Acura RDX AWD w/AcuraWatch Plus                                       73.7   \n",
       "2016 Acura RDX AWD 4-Door                                                  73.7   \n",
       "2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg                         73.7   \n",
       "2016 Acura RDX FWD 4-Door Tech Pkg                                         73.7   \n",
       "2016 Acura RDX FWD 4-Door Advance Pkg                                      73.7   \n",
       "2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg                              73.7   \n",
       "2016 Acura RDX FWD 4-Door                                                  73.7   \n",
       "2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg                         73.7   \n",
       "2016 Acura RDX AWD 4-Door Tech Pkg                                         73.7   \n",
       "2016 Acura RDX AWD 4-Door Advance Pkg                                      73.7   \n",
       "2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg                              73.7   \n",
       "2015 Acura RDX AWD 4-Door                                                  73.7   \n",
       "...                                                                         ...   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof...                         74.7   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof                            74.7   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD                                      74.7   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo                                          74.7   \n",
       "2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD                                 74.7   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo AWD                                      74.7   \n",
       "2019 Volvo S90 T5 AWD Momentum                                             74.4   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                             74.4   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                          74.4   \n",
       "2019 Volvo S90 T6 AWD Momentum                                             74.4   \n",
       "2019 Volvo S90 T6 AWD Inscription                                          74.4   \n",
       "2019 Volvo S90 T5 FWD Momentum                                             74.4   \n",
       "2017 Volvo S90 T5 FWD Inscription                                          74.0   \n",
       "2017 Volvo S90 T6 AWD Momentum                                             74.0   \n",
       "2017 Volvo S90 T6 AWD Inscription                                          74.0   \n",
       "2017 Volvo S90 T5 FWD Momentum                                             74.0   \n",
       "2018 Volvo S90 T5 AWD Momentum                                             74.4   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                             74.4   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                          74.4   \n",
       "2018 Volvo S90 T6 AWD Momentum                                             74.4   \n",
       "2018 Volvo S90 T6 AWD Inscription                                          74.4   \n",
       "2018 Volvo S90 T5 FWD Momentum                                             74.4   \n",
       "2018 Volvo V60 Cross Country T5 AWD                                        73.4   \n",
       "2018 Volvo V60 Cross Country T5 AWD Platinum                               73.4   \n",
       "2017 Volvo V60 Cross Country T5 AWD                                        73.4   \n",
       "2017 Volvo V60 Cross Country T5 AWD Platinum                               73.4   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD                           73.4   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 Pl...                         73.4   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                         73.4   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                         73.4   \n",
       "\n",
       "                                                    Third Gear Ratio (:1)  \\\n",
       "2017 Acura RDX FWD w/Technology/AcuraWatch Plus...                   1.48   \n",
       "2017 Acura RDX FWD w/Technology Pkg                                  1.48   \n",
       "2017 Acura RDX FWD w/Advance Pkg                                     1.48   \n",
       "2017 Acura RDX FWD w/AcuraWatch Plus                                 1.48   \n",
       "2017 Acura RDX FWD                                                   1.48   \n",
       "2017 Acura RDX AWD w/Technology/AcuraWatch Plus...                   1.48   \n",
       "2017 Acura RDX AWD w/Technology Pkg                                  1.48   \n",
       "2017 Acura RDX AWD w/Advance Pkg                                     1.48   \n",
       "2017 Acura RDX AWD w/AcuraWatch Plus                                 1.48   \n",
       "2018 Acura RDX AWD                                                   1.48   \n",
       "2018 Acura RDX FWD w/Technology/AcuraWatch Plus...                   1.48   \n",
       "2018 Acura RDX FWD w/Technology Pkg                                  1.48   \n",
       "2018 Acura RDX FWD w/Advance Pkg                                     1.48   \n",
       "2018 Acura RDX FWD w/AcuraWatch Plus                                 1.48   \n",
       "2018 Acura RDX FWD                                                   1.48   \n",
       "2018 Acura RDX AWD w/Technology/AcuraWatch Plus...                   1.48   \n",
       "2018 Acura RDX AWD w/Technology Pkg                                  1.48   \n",
       "2018 Acura RDX AWD w/Advance Pkg                                     1.48   \n",
       "2018 Acura RDX AWD w/AcuraWatch Plus                                 1.48   \n",
       "2016 Acura RDX AWD 4-Door                                            1.48   \n",
       "2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg                   1.48   \n",
       "2016 Acura RDX FWD 4-Door Tech Pkg                                   1.48   \n",
       "2016 Acura RDX FWD 4-Door Advance Pkg                                1.48   \n",
       "2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg                        1.48   \n",
       "2016 Acura RDX FWD 4-Door                                            1.48   \n",
       "2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg                   1.48   \n",
       "2016 Acura RDX AWD 4-Door Tech Pkg                                   1.48   \n",
       "2016 Acura RDX AWD 4-Door Advance Pkg                                1.48   \n",
       "2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg                        1.48   \n",
       "2015 Acura RDX AWD 4-Door                                            1.48   \n",
       "...                                                                   ...   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof...                   1.98   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof                      1.98   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD                                1.98   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo                                     NaN   \n",
       "2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD                            NaN   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo AWD                                 NaN   \n",
       "2019 Volvo S90 T5 AWD Momentum                                       1.95   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                       1.95   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                    1.95   \n",
       "2019 Volvo S90 T6 AWD Momentum                                       1.95   \n",
       "2019 Volvo S90 T6 AWD Inscription                                    1.95   \n",
       "2019 Volvo S90 T5 FWD Momentum                                       1.95   \n",
       "2017 Volvo S90 T5 FWD Inscription                                    1.95   \n",
       "2017 Volvo S90 T6 AWD Momentum                                       1.95   \n",
       "2017 Volvo S90 T6 AWD Inscription                                    1.95   \n",
       "2017 Volvo S90 T5 FWD Momentum                                       1.95   \n",
       "2018 Volvo S90 T5 AWD Momentum                                       1.95   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                       1.95   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                    1.95   \n",
       "2018 Volvo S90 T6 AWD Momentum                                       1.95   \n",
       "2018 Volvo S90 T6 AWD Inscription                                    1.95   \n",
       "2018 Volvo S90 T5 FWD Momentum                                       1.95   \n",
       "2018 Volvo V60 Cross Country T5 AWD                                  1.95   \n",
       "2018 Volvo V60 Cross Country T5 AWD Platinum                         1.95   \n",
       "2017 Volvo V60 Cross Country T5 AWD                                  1.95   \n",
       "2017 Volvo V60 Cross Country T5 AWD Platinum                         1.95   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD                     1.56   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 Pl...                   1.56   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                   1.56   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                   1.56   \n",
       "\n",
       "                                                    First Gear Ratio (:1)  \\\n",
       "2017 Acura RDX FWD w/Technology/AcuraWatch Plus...                   3.36   \n",
       "2017 Acura RDX FWD w/Technology Pkg                                  3.36   \n",
       "2017 Acura RDX FWD w/Advance Pkg                                     3.36   \n",
       "2017 Acura RDX FWD w/AcuraWatch Plus                                 3.36   \n",
       "2017 Acura RDX FWD                                                   3.36   \n",
       "2017 Acura RDX AWD w/Technology/AcuraWatch Plus...                   3.36   \n",
       "2017 Acura RDX AWD w/Technology Pkg                                  3.36   \n",
       "2017 Acura RDX AWD w/Advance Pkg                                     3.36   \n",
       "2017 Acura RDX AWD w/AcuraWatch Plus                                 3.36   \n",
       "2018 Acura RDX AWD                                                   3.36   \n",
       "2018 Acura RDX FWD w/Technology/AcuraWatch Plus...                   3.36   \n",
       "2018 Acura RDX FWD w/Technology Pkg                                  3.36   \n",
       "2018 Acura RDX FWD w/Advance Pkg                                     3.36   \n",
       "2018 Acura RDX FWD w/AcuraWatch Plus                                 3.36   \n",
       "2018 Acura RDX FWD                                                   3.36   \n",
       "2018 Acura RDX AWD w/Technology/AcuraWatch Plus...                   3.36   \n",
       "2018 Acura RDX AWD w/Technology Pkg                                  3.36   \n",
       "2018 Acura RDX AWD w/Advance Pkg                                     3.36   \n",
       "2018 Acura RDX AWD w/AcuraWatch Plus                                 3.36   \n",
       "2016 Acura RDX AWD 4-Door                                            3.36   \n",
       "2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg                   3.36   \n",
       "2016 Acura RDX FWD 4-Door Tech Pkg                                   3.36   \n",
       "2016 Acura RDX FWD 4-Door Advance Pkg                                3.36   \n",
       "2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg                        3.36   \n",
       "2016 Acura RDX FWD 4-Door                                            3.36   \n",
       "2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg                   3.36   \n",
       "2016 Acura RDX AWD 4-Door Tech Pkg                                   3.36   \n",
       "2016 Acura RDX AWD 4-Door Advance Pkg                                3.36   \n",
       "2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg                        3.36   \n",
       "2015 Acura RDX AWD 4-Door                                            3.36   \n",
       "...                                                                   ...   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof...                   4.66   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof                      4.66   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD                                4.66   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo                                     NaN   \n",
       "2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD                            NaN   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo AWD                                 NaN   \n",
       "2019 Volvo S90 T5 AWD Momentum                                       5.25   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                       5.25   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                    5.25   \n",
       "2019 Volvo S90 T6 AWD Momentum                                       5.25   \n",
       "2019 Volvo S90 T6 AWD Inscription                                    5.25   \n",
       "2019 Volvo S90 T5 FWD Momentum                                       5.25   \n",
       "2017 Volvo S90 T5 FWD Inscription                                    5.25   \n",
       "2017 Volvo S90 T6 AWD Momentum                                       5.25   \n",
       "2017 Volvo S90 T6 AWD Inscription                                    5.25   \n",
       "2017 Volvo S90 T5 FWD Momentum                                       5.25   \n",
       "2018 Volvo S90 T5 AWD Momentum                                       5.25   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                       5.25   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                    5.25   \n",
       "2018 Volvo S90 T6 AWD Momentum                                       5.25   \n",
       "2018 Volvo S90 T6 AWD Inscription                                    5.25   \n",
       "2018 Volvo S90 T5 FWD Momentum                                       5.25   \n",
       "2018 Volvo V60 Cross Country T5 AWD                                  5.25   \n",
       "2018 Volvo V60 Cross Country T5 AWD Platinum                         5.25   \n",
       "2017 Volvo V60 Cross Country T5 AWD                                  5.25   \n",
       "2017 Volvo V60 Cross Country T5 AWD Platinum                         5.25   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD                     4.15   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 Pl...                   4.15   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                   4.15   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                   4.15   \n",
       "\n",
       "                                                    Fourth Gear Ratio (:1)  \\\n",
       "2017 Acura RDX FWD w/Technology/AcuraWatch Plus...                    1.06   \n",
       "2017 Acura RDX FWD w/Technology Pkg                                   1.06   \n",
       "2017 Acura RDX FWD w/Advance Pkg                                      1.06   \n",
       "2017 Acura RDX FWD w/AcuraWatch Plus                                  1.06   \n",
       "2017 Acura RDX FWD                                                    1.06   \n",
       "2017 Acura RDX AWD w/Technology/AcuraWatch Plus...                    1.06   \n",
       "2017 Acura RDX AWD w/Technology Pkg                                   1.06   \n",
       "2017 Acura RDX AWD w/Advance Pkg                                      1.06   \n",
       "2017 Acura RDX AWD w/AcuraWatch Plus                                  1.06   \n",
       "2018 Acura RDX AWD                                                    1.06   \n",
       "2018 Acura RDX FWD w/Technology/AcuraWatch Plus...                    1.06   \n",
       "2018 Acura RDX FWD w/Technology Pkg                                   1.06   \n",
       "2018 Acura RDX FWD w/Advance Pkg                                      1.06   \n",
       "2018 Acura RDX FWD w/AcuraWatch Plus                                  1.06   \n",
       "2018 Acura RDX FWD                                                    1.06   \n",
       "2018 Acura RDX AWD w/Technology/AcuraWatch Plus...                    1.06   \n",
       "2018 Acura RDX AWD w/Technology Pkg                                   1.06   \n",
       "2018 Acura RDX AWD w/Advance Pkg                                      1.06   \n",
       "2018 Acura RDX AWD w/AcuraWatch Plus                                  1.06   \n",
       "2016 Acura RDX AWD 4-Door                                             1.06   \n",
       "2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg                    1.06   \n",
       "2016 Acura RDX FWD 4-Door Tech Pkg                                    1.06   \n",
       "2016 Acura RDX FWD 4-Door Advance Pkg                                 1.06   \n",
       "2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg                         1.06   \n",
       "2016 Acura RDX FWD 4-Door                                             1.06   \n",
       "2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg                    1.06   \n",
       "2016 Acura RDX AWD 4-Door Tech Pkg                                    1.06   \n",
       "2016 Acura RDX AWD 4-Door Advance Pkg                                 1.06   \n",
       "2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg                         1.06   \n",
       "2015 Acura RDX AWD 4-Door                                             1.06   \n",
       "...                                                                    ...   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof...                    1.34   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof                       1.34   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD                                 1.34   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo                                      NaN   \n",
       "2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD                             NaN   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo AWD                                  NaN   \n",
       "2019 Volvo S90 T5 AWD Momentum                                        1.46   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                        1.46   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                     1.46   \n",
       "2019 Volvo S90 T6 AWD Momentum                                        1.46   \n",
       "2019 Volvo S90 T6 AWD Inscription                                     1.46   \n",
       "2019 Volvo S90 T5 FWD Momentum                                        1.46   \n",
       "2017 Volvo S90 T5 FWD Inscription                                     1.46   \n",
       "2017 Volvo S90 T6 AWD Momentum                                        1.46   \n",
       "2017 Volvo S90 T6 AWD Inscription                                     1.46   \n",
       "2017 Volvo S90 T5 FWD Momentum                                        1.46   \n",
       "2018 Volvo S90 T5 AWD Momentum                                        1.46   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                        1.46   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                     1.46   \n",
       "2018 Volvo S90 T6 AWD Momentum                                        1.46   \n",
       "2018 Volvo S90 T6 AWD Inscription                                     1.46   \n",
       "2018 Volvo S90 T5 FWD Momentum                                        1.46   \n",
       "2018 Volvo V60 Cross Country T5 AWD                                   1.46   \n",
       "2018 Volvo V60 Cross Country T5 AWD Platinum                          1.46   \n",
       "2017 Volvo V60 Cross Country T5 AWD                                   1.46   \n",
       "2017 Volvo V60 Cross Country T5 AWD Platinum                          1.46   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD                      1.16   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 Pl...                    1.16   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                    1.16   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                    1.16   \n",
       "\n",
       "                                                    Second Gear Ratio (:1)  \\\n",
       "2017 Acura RDX FWD w/Technology/AcuraWatch Plus...                    2.09   \n",
       "2017 Acura RDX FWD w/Technology Pkg                                   2.09   \n",
       "2017 Acura RDX FWD w/Advance Pkg                                      2.09   \n",
       "2017 Acura RDX FWD w/AcuraWatch Plus                                  2.09   \n",
       "2017 Acura RDX FWD                                                    2.09   \n",
       "2017 Acura RDX AWD w/Technology/AcuraWatch Plus...                    2.09   \n",
       "2017 Acura RDX AWD w/Technology Pkg                                   2.09   \n",
       "2017 Acura RDX AWD w/Advance Pkg                                      2.09   \n",
       "2017 Acura RDX AWD w/AcuraWatch Plus                                  2.09   \n",
       "2018 Acura RDX AWD                                                    2.09   \n",
       "2018 Acura RDX FWD w/Technology/AcuraWatch Plus...                    2.09   \n",
       "2018 Acura RDX FWD w/Technology Pkg                                   2.09   \n",
       "2018 Acura RDX FWD w/Advance Pkg                                      2.09   \n",
       "2018 Acura RDX FWD w/AcuraWatch Plus                                  2.09   \n",
       "2018 Acura RDX FWD                                                    2.09   \n",
       "2018 Acura RDX AWD w/Technology/AcuraWatch Plus...                    2.09   \n",
       "2018 Acura RDX AWD w/Technology Pkg                                   2.09   \n",
       "2018 Acura RDX AWD w/Advance Pkg                                      2.09   \n",
       "2018 Acura RDX AWD w/AcuraWatch Plus                                  2.09   \n",
       "2016 Acura RDX AWD 4-Door                                             2.09   \n",
       "2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg                    2.09   \n",
       "2016 Acura RDX FWD 4-Door Tech Pkg                                    2.09   \n",
       "2016 Acura RDX FWD 4-Door Advance Pkg                                 2.09   \n",
       "2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg                         2.09   \n",
       "2016 Acura RDX FWD 4-Door                                             2.09   \n",
       "2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg                    2.09   \n",
       "2016 Acura RDX AWD 4-Door Tech Pkg                                    2.09   \n",
       "2016 Acura RDX AWD 4-Door Advance Pkg                                 2.09   \n",
       "2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg                         2.09   \n",
       "2015 Acura RDX AWD 4-Door                                             2.09   \n",
       "...                                                                    ...   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof...                    3.03   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof                       3.03   \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD                                 3.03   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo                                      NaN   \n",
       "2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD                             NaN   \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo AWD                                  NaN   \n",
       "2019 Volvo S90 T5 AWD Momentum                                        3.03   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                        3.03   \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                     3.03   \n",
       "2019 Volvo S90 T6 AWD Momentum                                        3.03   \n",
       "2019 Volvo S90 T6 AWD Inscription                                     3.03   \n",
       "2019 Volvo S90 T5 FWD Momentum                                        3.03   \n",
       "2017 Volvo S90 T5 FWD Inscription                                     3.03   \n",
       "2017 Volvo S90 T6 AWD Momentum                                        3.03   \n",
       "2017 Volvo S90 T6 AWD Inscription                                     3.03   \n",
       "2017 Volvo S90 T5 FWD Momentum                                        3.03   \n",
       "2018 Volvo S90 T5 AWD Momentum                                        3.03   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                        3.03   \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                     3.03   \n",
       "2018 Volvo S90 T6 AWD Momentum                                        3.03   \n",
       "2018 Volvo S90 T6 AWD Inscription                                     3.03   \n",
       "2018 Volvo S90 T5 FWD Momentum                                        3.03   \n",
       "2018 Volvo V60 Cross Country T5 AWD                                   3.03   \n",
       "2018 Volvo V60 Cross Country T5 AWD Platinum                          3.03   \n",
       "2017 Volvo V60 Cross Country T5 AWD                                   3.03   \n",
       "2017 Volvo V60 Cross Country T5 AWD Platinum                          3.03   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD                      2.37   \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 Pl...                    2.37   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                    2.37   \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                    2.37   \n",
       "\n",
       "                                                    Turning Diameter - Curb to Curb  \n",
       "2017 Acura RDX FWD w/Technology/AcuraWatch Plus...                             38.9  \n",
       "2017 Acura RDX FWD w/Technology Pkg                                            38.9  \n",
       "2017 Acura RDX FWD w/Advance Pkg                                               38.9  \n",
       "2017 Acura RDX FWD w/AcuraWatch Plus                                           38.9  \n",
       "2017 Acura RDX FWD                                                             38.9  \n",
       "2017 Acura RDX AWD w/Technology/AcuraWatch Plus...                             38.9  \n",
       "2017 Acura RDX AWD w/Technology Pkg                                            38.9  \n",
       "2017 Acura RDX AWD w/Advance Pkg                                               38.9  \n",
       "2017 Acura RDX AWD w/AcuraWatch Plus                                           38.9  \n",
       "2018 Acura RDX AWD                                                             38.9  \n",
       "2018 Acura RDX FWD w/Technology/AcuraWatch Plus...                             38.9  \n",
       "2018 Acura RDX FWD w/Technology Pkg                                            38.9  \n",
       "2018 Acura RDX FWD w/Advance Pkg                                               38.9  \n",
       "2018 Acura RDX FWD w/AcuraWatch Plus                                           38.9  \n",
       "2018 Acura RDX FWD                                                             38.9  \n",
       "2018 Acura RDX AWD w/Technology/AcuraWatch Plus...                             38.9  \n",
       "2018 Acura RDX AWD w/Technology Pkg                                            38.9  \n",
       "2018 Acura RDX AWD w/Advance Pkg                                               38.9  \n",
       "2018 Acura RDX AWD w/AcuraWatch Plus                                           38.9  \n",
       "2016 Acura RDX AWD 4-Door                                                      38.9  \n",
       "2016 Acura RDX FWD 4-Door Tech/AcuraWatch Plus Pkg                             38.9  \n",
       "2016 Acura RDX FWD 4-Door Tech Pkg                                             38.9  \n",
       "2016 Acura RDX FWD 4-Door Advance Pkg                                          38.9  \n",
       "2016 Acura RDX FWD 4-Door AcuraWatch Plus Pkg                                  38.9  \n",
       "2016 Acura RDX FWD 4-Door                                                      38.9  \n",
       "2016 Acura RDX AWD 4-Door Tech/AcuraWatch Plus Pkg                             38.9  \n",
       "2016 Acura RDX AWD 4-Door Tech Pkg                                             38.9  \n",
       "2016 Acura RDX AWD 4-Door Advance Pkg                                          38.9  \n",
       "2016 Acura RDX AWD 4-Door AcuraWatch Plus Pkg                                  38.9  \n",
       "2015 Acura RDX AWD 4-Door                                                      38.9  \n",
       "...                                                                             ...  \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof...                             39.0  \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD w/Sunroof                                39.0  \n",
       "2004 Volvo XC90 4-Door 2.5L Turbo AWD                                          39.0  \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo                                              39.0  \n",
       "2003 Volvo XC90 4-Door 2.9L Twin Turbo AWD                                     39.0  \n",
       "2003 Volvo XC90 4-Door 2.5L Turbo AWD                                          39.0  \n",
       "2019 Volvo S90 T5 AWD Momentum                                                 38.7  \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                                 38.7  \n",
       "2019 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                              38.7  \n",
       "2019 Volvo S90 T6 AWD Momentum                                                 38.7  \n",
       "2019 Volvo S90 T6 AWD Inscription                                              38.7  \n",
       "2019 Volvo S90 T5 FWD Momentum                                                 38.7  \n",
       "2017 Volvo S90 T5 FWD Inscription                                              37.4  \n",
       "2017 Volvo S90 T6 AWD Momentum                                                 37.4  \n",
       "2017 Volvo S90 T6 AWD Inscription                                              37.4  \n",
       "2017 Volvo S90 T5 FWD Momentum                                                 37.4  \n",
       "2018 Volvo S90 T5 AWD Momentum                                                 38.7  \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Momentum                                 38.7  \n",
       "2018 Volvo S90 T8 eAWD Plug-In Hybrid Inscription                              38.7  \n",
       "2018 Volvo S90 T6 AWD Momentum                                                 38.7  \n",
       "2018 Volvo S90 T6 AWD Inscription                                              38.7  \n",
       "2018 Volvo S90 T5 FWD Momentum                                                 38.7  \n",
       "2018 Volvo V60 Cross Country T5 AWD                                            37.1  \n",
       "2018 Volvo V60 Cross Country T5 AWD Platinum                                   37.1  \n",
       "2017 Volvo V60 Cross Country T5 AWD                                            37.1  \n",
       "2017 Volvo V60 Cross Country T5 AWD Platinum                                   37.1  \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 AWD                               37.1  \n",
       "2016 Volvo V60 Cross Country 4-Door Wagon T5 Pl...                             37.1  \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                             37.1  \n",
       "2015 Volvo V60 Cross Country 2015.5 4-Door Wago...                             37.1  \n",
       "\n",
       "[31738 rows x 14 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imputed_data[specs_to_mean]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "list_col = imputed_data.columns.tolist()\n",
    "\n",
    "specs_to_mode = list_col.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "for item in specs_to_mean:\n",
    "    specs_to_mode.remove(item)\n",
    "    \n",
    "\n",
    "specs_to_mode.remove('MSRP')\n",
    "specs_to_mode.remove('Make')\n",
    "specs_to_mode.remove('Model')\n",
    "specs_to_mode.remove('Style Name')\n",
    "specs_to_mode.remove('Body Style')\n",
    "specs_to_mode.remove('EPA Classification')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "#specs_to_mode"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "def imputer_mean(x, y):\n",
    "    temp_list_model = raw_data.loc[raw_data[\"Model\"] == raw_data.loc[x, \"Model\"]].loc[:, y].dropna()\n",
    "    if len(temp_list_model) > 0:\n",
    "        imputed_data.loc[x, y] = np.round(temp_list_model.mean(), 2)\n",
    "    else:\n",
    "        temp_list_epa = raw_data.loc[raw_data[\"EPA Classification\"]\n",
    "                                                == raw_data.loc[x, \"EPA Classification\"]].loc[:, y].dropna()\n",
    "        if len(temp_list_epa) > 0:\n",
    "            imputed_data.loc[x, y] = np.round(temp_list_epa.mean(), 2)\n",
    "        else:\n",
    "            temp_list_bodystyle = raw_data.loc[raw_data[\"Body Style\"] ==\n",
    "                                                        raw_data.loc[x, \"Body Style\"]].loc[:, y].dropna()\n",
    "            if len(temp_list_bodystyle) > 0:\n",
    "                imputed_data.loc[x, y] = np.round(temp_list_bodystyle.mean(), 2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "def imputer_mode(x, y):\n",
    "    temp_list_model = pd.Series(raw_data.loc[raw_data[\"Model\"] == raw_data.loc[x, \"Model\"]].loc[:, y].dropna())\n",
    "    if len(temp_list_model) > 0:\n",
    "        imputed_data.loc[x, y] = stats.mode(temp_list_model)[0][0]\n",
    "    else:\n",
    "        temp_list_epa = raw_data.loc[raw_data[\"EPA Classification\"]\n",
    "                                                == raw_data.loc[x, \"EPA Classification\"]].loc[:, y].dropna()\n",
    "        if len(temp_list_epa) > 0:\n",
    "            imputed_data.loc[x, y] = stats.mode(temp_list_epa)[0][0]\n",
    "        else:\n",
    "            temp_list_bodystyle = raw_data.loc[raw_data[\"Body Style\"] ==\n",
    "                                                        raw_data.loc[x, \"Body Style\"]].loc[:, y].dropna()\n",
    "            if len(temp_list_bodystyle) > 0:\n",
    "                imputed_data.loc[x, y] = stats.mode(temp_list_bodystyle)[0][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "85049"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "raw_data.isnull().sum().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1/14 Front Shoulder Room (in)\n",
      "2/14 Front Head Room (in)\n",
      "3/14 Second Leg Room (in)\n",
      "4/14 Front Leg Room (in)\n",
      "5/14 Second Shoulder Room (in)\n",
      "6/14 Second Head Room (in)\n",
      "7/14 Height, Overall (in)\n",
      "8/14 Wheelbase (in)\n",
      "9/14 Width, Max w/o mirrors (in)\n",
      "10/14 Third Gear Ratio (:1)\n",
      "11/14 First Gear Ratio (:1)\n",
      "12/14 Fourth Gear Ratio (:1)\n",
      "13/14 Second Gear Ratio (:1)\n",
      "14/14 Turning Diameter - Curb to Curb\n"
     ]
    }
   ],
   "source": [
    "ix = 0\n",
    "for col in specs_to_mean:\n",
    "    for row in imputed_data.index:\n",
    "        val = imputed_data.at[row, col]\n",
    "        if pd.isnull(val):\n",
    "            raw_data.at[row,col] = imputer_mean(row, col)\n",
    "    ix += 1\n",
    "    print(str(ix)+'/'+str(len(specs_to_mean)), col)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "54986"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imputed_data.isnull().sum().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1/61 Drivetrain\n",
      "2/61 Passenger Capacity\n",
      "3/61 Passenger Doors\n",
      "4/61 Fuel Tank Capacity, Approx (gal)\n",
      "5/61 EPA Fuel Economy Est - Hwy (MPG)\n",
      "6/61 EPA Fuel Economy Est - City (MPG)\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Nicolas\\Miniconda3\\envs\\tfenv\\lib\\site-packages\\scipy\\stats\\stats.py:248: RuntimeWarning: The input array could not be properly checked for nan values. nan values will be ignored.\n",
      "  \"values. nan values will be ignored.\", RuntimeWarning)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "7/61 Fuel System\n",
      "8/61 Front Brake Rotor Diam x Thickness (in)\n",
      "9/61 Rear Brake Rotor Diam x Thickness (in)\n",
      "10/61 Steering Type\n",
      "11/61 Rear Wheel Material\n",
      "12/61 Suspension Type - Front\n",
      "13/61 Air Bag-Frontal-Driver\n",
      "14/61 Air Bag-Frontal-Passenger\n",
      "15/61 Air Bag-Passenger Switch (On/Off)\n",
      "16/61 Air Bag-Side Body-Front\n",
      "17/61 Air Bag-Side Body-Rear\n",
      "18/61 Air Bag-Side Head-Front\n",
      "19/61 Air Bag-Side Head-Rear\n",
      "20/61 Brakes-ABS\n",
      "21/61 Child Safety Rear Door Locks\n",
      "22/61 Daytime Running Lights\n",
      "23/61 Traction Control\n",
      "24/61 Night Vision\n",
      "25/61 Rollover Protection Bars\n",
      "26/61 Fog Lamps\n",
      "27/61 Parking Aid\n",
      "28/61 Tire Pressure Monitor\n",
      "29/61 Back-Up Camera\n",
      "30/61 Stability Control\n",
      "31/61 Other Features\n",
      "32/61 Basic Miles/km\n",
      "33/61 Basic Years\n",
      "34/61 Corrosion Miles/km\n",
      "35/61 Corrosion Years\n",
      "36/61 Drivetrain Miles/km\n",
      "37/61 Drivetrain Years\n",
      "38/61 Roadside Assistance Miles/km\n",
      "39/61 Roadside Assistance Years\n",
      "40/61 Hybrid Engine\n",
      "41/61 Gears\n",
      "42/61 Net Horsepower\n",
      "43/61 Net Horsepower RPM\n",
      "44/61 Net Torque\n",
      "45/61 Net Torque RPM\n",
      "46/61 Cylinders\n",
      "47/61 Engine Configuration\n",
      "48/61 Displacement (L)\n",
      "49/61 Displacement (cc)\n",
      "50/61 Rear Tire Width\n",
      "51/61 Front Tire Width\n",
      "52/61 Rear Wheel Size\n",
      "53/61 Front Wheel Size\n",
      "54/61 Tire Rating\n",
      "55/61 Tire Width Ratio\n",
      "56/61 Wheel Size Ratio\n",
      "57/61 Tire Ratio\n",
      "58/61 Year\n",
      "59/61 Country\n",
      "60/61 Country Code\n",
      "61/61 Category\n"
     ]
    }
   ],
   "source": [
    "ix = 0\n",
    "for col in specs_to_mode:\n",
    "    for row in imputed_data.index:\n",
    "        val = imputed_data.at[row, col]\n",
    "        if pd.isnull(val):\n",
    "            raw_data.at[row, col] = imputer_mode(row, col)\n",
    "    ix += 1\n",
    "    print(str(ix)+'/'+str(len(specs_to_mode)), col)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "12850"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imputed_data.isnull().sum().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MSRP                                          70\n",
       "Make                                           3\n",
       "Model                                          3\n",
       "Style Name                                     3\n",
       "Drivetrain                                     3\n",
       "Passenger Capacity                             3\n",
       "Passenger Doors                                3\n",
       "Body Style                                     5\n",
       "EPA Classification                         10990\n",
       "Front Shoulder Room (in)                       3\n",
       "Front Head Room (in)                           3\n",
       "Second Leg Room (in)                         432\n",
       "Front Leg Room (in)                            3\n",
       "Second Shoulder Room (in)                    432\n",
       "Second Head Room (in)                        432\n",
       "Height, Overall (in)                           3\n",
       "Wheelbase (in)                                 3\n",
       "Width, Max w/o mirrors (in)                    3\n",
       "Fuel Tank Capacity, Approx (gal)               3\n",
       "EPA Fuel Economy Est - Hwy (MPG)             135\n",
       "EPA Fuel Economy Est - City (MPG)            135\n",
       "Fuel System                                    3\n",
       "Third Gear Ratio (:1)                          3\n",
       "First Gear Ratio (:1)                          3\n",
       "Fourth Gear Ratio (:1)                         3\n",
       "Second Gear Ratio (:1)                         3\n",
       "Front Brake Rotor Diam x Thickness (in)        3\n",
       "Rear Brake Rotor Diam x Thickness (in)         3\n",
       "Steering Type                                  3\n",
       "Turning Diameter - Curb to Curb                3\n",
       "                                           ...  \n",
       "Basic Miles/km                                 3\n",
       "Basic Years                                    3\n",
       "Corrosion Miles/km                             3\n",
       "Corrosion Years                                3\n",
       "Drivetrain Miles/km                            3\n",
       "Drivetrain Years                               3\n",
       "Roadside Assistance Miles/km                   3\n",
       "Roadside Assistance Years                      3\n",
       "Hybrid Engine                                  3\n",
       "Gears                                          3\n",
       "Net Horsepower                                 3\n",
       "Net Horsepower RPM                             3\n",
       "Net Torque                                     3\n",
       "Net Torque RPM                                 3\n",
       "Cylinders                                      3\n",
       "Engine Configuration                           3\n",
       "Displacement (L)                               3\n",
       "Displacement (cc)                              3\n",
       "Rear Tire Width                                3\n",
       "Front Tire Width                               3\n",
       "Rear Wheel Size                                3\n",
       "Front Wheel Size                               3\n",
       "Tire Rating                                    3\n",
       "Tire Width Ratio                               3\n",
       "Wheel Size Ratio                               3\n",
       "Tire Ratio                                     3\n",
       "Year                                           3\n",
       "Country                                        3\n",
       "Country Code                                   3\n",
       "Category                                       3\n",
       "Length: 81, dtype: int64"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imputed_data.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "imputed_data['EPA Classification'] = imputed_data['EPA Classification'].fillna('None')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MSRP                                        70\n",
       "Make                                         3\n",
       "Model                                        3\n",
       "Style Name                                   3\n",
       "Drivetrain                                   3\n",
       "Passenger Capacity                           3\n",
       "Passenger Doors                              3\n",
       "Body Style                                   5\n",
       "EPA Classification                           0\n",
       "Front Shoulder Room (in)                     3\n",
       "Front Head Room (in)                         3\n",
       "Second Leg Room (in)                       432\n",
       "Front Leg Room (in)                          3\n",
       "Second Shoulder Room (in)                  432\n",
       "Second Head Room (in)                      432\n",
       "Height, Overall (in)                         3\n",
       "Wheelbase (in)                               3\n",
       "Width, Max w/o mirrors (in)                  3\n",
       "Fuel Tank Capacity, Approx (gal)             3\n",
       "EPA Fuel Economy Est - Hwy (MPG)           135\n",
       "EPA Fuel Economy Est - City (MPG)          135\n",
       "Fuel System                                  3\n",
       "Third Gear Ratio (:1)                        3\n",
       "First Gear Ratio (:1)                        3\n",
       "Fourth Gear Ratio (:1)                       3\n",
       "Second Gear Ratio (:1)                       3\n",
       "Front Brake Rotor Diam x Thickness (in)      3\n",
       "Rear Brake Rotor Diam x Thickness (in)       3\n",
       "Steering Type                                3\n",
       "Turning Diameter - Curb to Curb              3\n",
       "                                          ... \n",
       "Basic Miles/km                               3\n",
       "Basic Years                                  3\n",
       "Corrosion Miles/km                           3\n",
       "Corrosion Years                              3\n",
       "Drivetrain Miles/km                          3\n",
       "Drivetrain Years                             3\n",
       "Roadside Assistance Miles/km                 3\n",
       "Roadside Assistance Years                    3\n",
       "Hybrid Engine                                3\n",
       "Gears                                        3\n",
       "Net Horsepower                               3\n",
       "Net Horsepower RPM                           3\n",
       "Net Torque                                   3\n",
       "Net Torque RPM                               3\n",
       "Cylinders                                    3\n",
       "Engine Configuration                         3\n",
       "Displacement (L)                             3\n",
       "Displacement (cc)                            3\n",
       "Rear Tire Width                              3\n",
       "Front Tire Width                             3\n",
       "Rear Wheel Size                              3\n",
       "Front Wheel Size                             3\n",
       "Tire Rating                                  3\n",
       "Tire Width Ratio                             3\n",
       "Wheel Size Ratio                             3\n",
       "Tire Ratio                                   3\n",
       "Year                                         3\n",
       "Country                                      3\n",
       "Country Code                                 3\n",
       "Category                                     3\n",
       "Length: 81, dtype: int64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imputed_data.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "31738"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(imputed_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1860"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imputed_data.isnull().sum().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "imputed_data.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['MSRP', 'Make', 'Model', 'Style Name', 'Drivetrain',\n",
       "       'Passenger Capacity', 'Passenger Doors', 'Body Style',\n",
       "       'EPA Classification', 'Front Shoulder Room (in)',\n",
       "       'Front Head Room (in)', 'Second Leg Room (in)', 'Front Leg Room (in)',\n",
       "       'Second Shoulder Room (in)', 'Second Head Room (in)',\n",
       "       'Height, Overall (in)', 'Wheelbase (in)', 'Width, Max w/o mirrors (in)',\n",
       "       'Fuel Tank Capacity, Approx (gal)', 'EPA Fuel Economy Est - Hwy (MPG)',\n",
       "       'EPA Fuel Economy Est - City (MPG)', 'Fuel System',\n",
       "       'Third Gear Ratio (:1)', 'First Gear Ratio (:1)',\n",
       "       'Fourth Gear Ratio (:1)', 'Second Gear Ratio (:1)',\n",
       "       'Front Brake Rotor Diam x Thickness (in)',\n",
       "       'Rear Brake Rotor Diam x Thickness (in)', 'Steering Type',\n",
       "       'Turning Diameter - Curb to Curb', 'Rear Wheel Material',\n",
       "       'Suspension Type - Front', 'Air Bag-Frontal-Driver',\n",
       "       'Air Bag-Frontal-Passenger', 'Air Bag-Passenger Switch (On/Off)',\n",
       "       'Air Bag-Side Body-Front', 'Air Bag-Side Body-Rear',\n",
       "       'Air Bag-Side Head-Front', 'Air Bag-Side Head-Rear', 'Brakes-ABS',\n",
       "       'Child Safety Rear Door Locks', 'Daytime Running Lights',\n",
       "       'Traction Control', 'Night Vision', 'Rollover Protection Bars',\n",
       "       'Fog Lamps', 'Parking Aid', 'Tire Pressure Monitor', 'Back-Up Camera',\n",
       "       'Stability Control', 'Other Features', 'Basic Miles/km', 'Basic Years',\n",
       "       'Corrosion Miles/km', 'Corrosion Years', 'Drivetrain Miles/km',\n",
       "       'Drivetrain Years', 'Roadside Assistance Miles/km',\n",
       "       'Roadside Assistance Years', 'Hybrid Engine', 'Gears', 'Net Horsepower',\n",
       "       'Net Horsepower RPM', 'Net Torque', 'Net Torque RPM', 'Cylinders',\n",
       "       'Engine Configuration', 'Displacement (L)', 'Displacement (cc)',\n",
       "       'Rear Tire Width', 'Front Tire Width', 'Rear Wheel Size',\n",
       "       'Front Wheel Size', 'Tire Rating', 'Tire Width Ratio',\n",
       "       'Wheel Size Ratio', 'Tire Ratio', 'Year', 'Country', 'Country Code',\n",
       "       'Category'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imputed_data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "specs_to_dummies = ['Drivetrain', 'Body Style',  'EPA Classification', 'Fuel System',\n",
    "       'Steering Type', 'Rear Wheel Material', 'Suspension Type - Front', 'Air Bag-Frontal-Driver',\n",
    "       'Air Bag-Frontal-Passenger', 'Air Bag-Passenger Switch (On/Off)',\n",
    "       'Air Bag-Side Body-Front', 'Air Bag-Side Body-Rear',\n",
    "       'Air Bag-Side Head-Front', 'Air Bag-Side Head-Rear', 'Brakes-ABS',\n",
    "       'Child Safety Rear Door Locks', 'Daytime Running Lights',\n",
    "       'Traction Control', 'Night Vision', 'Rollover Protection Bars',\n",
    "       'Fog Lamps', 'Parking Aid', 'Tire Pressure Monitor', 'Back-Up Camera',\n",
    "       'Stability Control', 'Hybrid Engine', 'Engine Configuration', 'Tire Rating', \n",
    "       'Country', 'Category']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "for item in specs_to_dummies:\n",
    "    dummies = pd.get_dummies(imputed_data[item], prefix_sep=': ', prefix=item)\n",
    "    imputed_data = pd.concat([imputed_data, dummies], sort=False, axis=1)\n",
    "\n",
    "#df = df.drop(specs_to_dummies, axis=1)\n",
    "imputed_data = imputed_data.drop('Other Features', axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "MSRP\n",
      "Make\n",
      "Model\n",
      "Style Name\n",
      "Drivetrain\n",
      "Passenger Capacity\n",
      "Passenger Doors\n",
      "Body Style\n",
      "EPA Classification\n",
      "Front Shoulder Room (in)\n",
      "Front Head Room (in)\n",
      "Second Leg Room (in)\n",
      "Front Leg Room (in)\n",
      "Second Shoulder Room (in)\n",
      "Second Head Room (in)\n",
      "Height, Overall (in)\n",
      "Wheelbase (in)\n",
      "Width, Max w/o mirrors (in)\n",
      "Fuel Tank Capacity, Approx (gal)\n",
      "EPA Fuel Economy Est - Hwy (MPG)\n",
      "EPA Fuel Economy Est - City (MPG)\n",
      "Fuel System\n",
      "Third Gear Ratio (:1)\n",
      "First Gear Ratio (:1)\n",
      "Fourth Gear Ratio (:1)\n",
      "Second Gear Ratio (:1)\n",
      "Front Brake Rotor Diam x Thickness (in)\n",
      "Rear Brake Rotor Diam x Thickness (in)\n",
      "Steering Type\n",
      "Turning Diameter - Curb to Curb\n",
      "Rear Wheel Material\n",
      "Suspension Type - Front\n",
      "Air Bag-Frontal-Driver\n",
      "Air Bag-Frontal-Passenger\n",
      "Air Bag-Passenger Switch (On/Off)\n",
      "Air Bag-Side Body-Front\n",
      "Air Bag-Side Body-Rear\n",
      "Air Bag-Side Head-Front\n",
      "Air Bag-Side Head-Rear\n",
      "Brakes-ABS\n",
      "Child Safety Rear Door Locks\n",
      "Daytime Running Lights\n",
      "Traction Control\n",
      "Night Vision\n",
      "Rollover Protection Bars\n",
      "Fog Lamps\n",
      "Parking Aid\n",
      "Tire Pressure Monitor\n",
      "Back-Up Camera\n",
      "Stability Control\n",
      "Basic Miles/km\n",
      "Basic Years\n",
      "Corrosion Miles/km\n",
      "Corrosion Years\n",
      "Drivetrain Miles/km\n",
      "Drivetrain Years\n",
      "Roadside Assistance Miles/km\n",
      "Roadside Assistance Years\n",
      "Hybrid Engine\n",
      "Gears\n",
      "Net Horsepower\n",
      "Net Horsepower RPM\n",
      "Net Torque\n",
      "Net Torque RPM\n",
      "Cylinders\n",
      "Engine Configuration\n",
      "Displacement (L)\n",
      "Displacement (cc)\n",
      "Rear Tire Width\n",
      "Front Tire Width\n",
      "Rear Wheel Size\n",
      "Front Wheel Size\n",
      "Tire Rating\n",
      "Tire Width Ratio\n",
      "Wheel Size Ratio\n",
      "Tire Ratio\n",
      "Year\n",
      "Country\n",
      "Country Code\n",
      "Category\n",
      "Drivetrain: All Wheel Drive\n",
      "Drivetrain: Four Wheel Drive\n",
      "Drivetrain: Front Wheel Drive\n",
      "Drivetrain: Rear Wheel Drive\n",
      "Body Style: 2dr Car\n",
      "Body Style: 3dr Car\n",
      "Body Style: 4dr Car\n",
      "Body Style: Convertible\n",
      "Body Style: Crew Cab Pickup - Standard Bed - Long Bed\n",
      "Body Style: Crew Cab Pickup - Standard Bed - Short Bed\n",
      "Body Style: Crew Cab Pickup - Standard Bed - Standard Bed\n",
      "Body Style: Extended Cab Pickup - Standard Bed - Long Bed\n",
      "Body Style: Extended Cab Pickup - Standard Bed - Short Bed\n",
      "Body Style: Extended Cab Pickup - Standard Bed - Standard Bed\n",
      "Body Style: Full-size Cargo Van\n",
      "Body Style: Full-size Passenger Van\n",
      "Body Style: Mini-van, Cargo\n",
      "Body Style: Mini-van, Passenger\n",
      "Body Style: Regular Cab Pickup - Long Bed\n",
      "Body Style: Regular Cab Pickup - Short Bed\n",
      "Body Style: Regular Cab Pickup - Standard Bed\n",
      "Body Style: Sport Utility\n",
      "Body Style: Station Wagon\n",
      "EPA Classification: 2WD Minivan\n",
      "EPA Classification: 4WD Minivan\n",
      "EPA Classification: 4WD Special Purpose\n",
      "EPA Classification: Compact\n",
      "EPA Classification: Large\n",
      "EPA Classification: Midsize\n",
      "EPA Classification: Midsize Station Wagon\n",
      "EPA Classification: Minicompact\n",
      "EPA Classification: None\n",
      "EPA Classification: SUV\n",
      "EPA Classification: SUV 2WD\n",
      "EPA Classification: SUV 4WD\n",
      "EPA Classification: Small SUV 2WD\n",
      "EPA Classification: Small SUV 4WD\n",
      "EPA Classification: Small Station Wagon\n",
      "EPA Classification: Special Purpose\n",
      "EPA Classification: Special Purpose 2WD\n",
      "EPA Classification: Subcompact\n",
      "EPA Classification: Two Seater\n",
      "Fuel System: CDI\n",
      "Fuel System: CRD\n",
      "Fuel System: DI\n",
      "Fuel System: DIS\n",
      "Fuel System: DISI\n",
      "Fuel System: DOHC FSI Direct\n",
      "Fuel System: Diesel Direct Injection\n",
      "Fuel System: Direct\n",
      "Fuel System: Direct Gasoline Injection\n",
      "Fuel System: Direct Injection\n",
      "Fuel System: Direct injection\n",
      "Fuel System: EFI\n",
      "Fuel System: EMPI\n",
      "Fuel System: Electric\n",
      "Fuel System: FFV\n",
      "Fuel System: FI\n",
      "Fuel System: FSI\n",
      "Fuel System: FSI Direct\n",
      "Fuel System: GDI\n",
      "Fuel System: Gasoline Direct Injection\n",
      "Fuel System: HPI\n",
      "Fuel System: Hydrogen\n",
      "Fuel System: MPI\n",
      "Fuel System: NDIS\n",
      "Fuel System: PFI\n",
      "Fuel System: PGM-FI\n",
      "Fuel System: PGM-FI MPI\n",
      "Fuel System: Port/Direct Injection\n",
      "Fuel System: SDI\n",
      "Fuel System: SEFI\n",
      "Fuel System: SFI\n",
      "Fuel System: SFI FlexFuel\n",
      "Fuel System: SFI/DI\n",
      "Fuel System: SI\n",
      "Fuel System: SIDI\n",
      "Fuel System: SMPI\n",
      "Fuel System: SMPI (injection)\n",
      "Fuel System: SPFI\n",
      "Fuel System: SPI\n",
      "Fuel System: Sequential Fuel Injection\n",
      "Fuel System: Supercharged EFI\n",
      "Fuel System: TDI\n",
      "Fuel System: TFSI\n",
      "Fuel System: TFSI Direct\n",
      "Fuel System: Turbo-Charged DI\n",
      "Fuel System: Turbo-Charged OHV\n",
      "Fuel System: Turbo-Diesel\n",
      "Fuel System: Turbocharged\n",
      "Fuel System: Turbocharged DI\n",
      "Fuel System: Turbocharged EFI\n",
      "Fuel System: Turbocharged FSI\n",
      "Fuel System: Turbocharged SMPI\n",
      "Steering Type: 4 Wheel Power Rack Pinion\n",
      "Steering Type: Electric\n",
      "Steering Type: Electric Power\n",
      "Steering Type: Electric Power Rack Pinion\n",
      "Steering Type: Electric Rack Pinion\n",
      "Steering Type: Electric Variable Effort Power\n",
      "Steering Type: Electric Variable Power Rack Pinion\n",
      "Steering Type: Electromechanical\n",
      "Steering Type: Hydraulic Assist Power\n",
      "Steering Type: Hydraulic Power\n",
      "Steering Type: Hydraulic Power Rack Pinion\n",
      "Steering Type: Hydraulic Recirculating Ball\n",
      "Steering Type: M Servotronic Variable Assist Power\n",
      "Steering Type: Performance\n",
      "Steering Type: Performance Rack Pinion\n",
      "Steering Type: Performance Tune\n",
      "Steering Type: Power\n",
      "Steering Type: Power Ball And Nut\n",
      "Steering Type: Power Electric Assist\n",
      "Steering Type: Power Rack Pinion\n",
      "Steering Type: Power Rack Pinion W/Electric Variable Assist\n",
      "Steering Type: Power Rack Pinion W/Hydraulic Variable Assist\n",
      "Steering Type: Power Recirculating Ball\n",
      "Steering Type: Power Speed Sensitive\n",
      "Steering Type: Power Speed Sensitive Rack Pinion\n",
      "Steering Type: Power Speed Sensitive Recirculating Ball\n",
      "Steering Type: Power Variable\n",
      "Steering Type: Power Worm & Roller\n",
      "Steering Type: Quick Ratio Power Rack Pinion\n",
      "Steering Type: Rack Pinion\n",
      "Steering Type: Recirculating Ball\n",
      "Steering Type: Servotronic\n",
      "Steering Type: Servotronic Power Assist\n",
      "Steering Type: Servotronic Speed Sensitive\n",
      "Steering Type: Servotronic Variable Assist Power\n",
      "Steering Type: Speed Sensitive\n",
      "Steering Type: Speed Sensitive Rack Pinion\n",
      "Steering Type: Variable Assist Power\n",
      "Steering Type: Variable Assist Power Assist\n",
      "Steering Type: Variable Assist Power Rack Pinion\n",
      "Steering Type: Variable Assist Power Recirculating Ball\n",
      "Steering Type: Variable Effort Power\n",
      "Steering Type: Variable Power Rack Pinion\n",
      "Steering Type: Variable Rate Power Rack Pinion\n",
      "Rear Wheel Material: Alloy\n",
      "Rear Wheel Material: Aluminum\n",
      "Rear Wheel Material: Carbon Fibre\n",
      "Rear Wheel Material: Chrome\n",
      "Rear Wheel Material: Forged Aluminum\n",
      "Rear Wheel Material: Steel\n",
      "Rear Wheel Material: Styled Steel\n",
      "Suspension Type - Front: 3 Link\n",
      "Suspension Type - Front: Active Damping\n",
      "Suspension Type - Front: Adaptive Air\n",
      "Suspension Type - Front: Air\n",
      "Suspension Type - Front: Air Springs\n",
      "Suspension Type - Front: Aluminum Sla\n",
      "Suspension Type - Front: Coil\n",
      "Suspension Type - Front: Coil Over\n",
      "Suspension Type - Front: Coil Over Shock\n",
      "Suspension Type - Front: Coil Over Strut\n",
      "Suspension Type - Front: Coils\n",
      "Suspension Type - Front: Control Arm\n",
      "Suspension Type - Front: Control Link\n",
      "Suspension Type - Front: Double Joint Strut\n",
      "Suspension Type - Front: Double Pivot\n",
      "Suspension Type - Front: Double Pivot Strut\n",
      "Suspension Type - Front: Double Wishbone\n",
      "Suspension Type - Front: Double Wishbone Pushrod\n",
      "Suspension Type - Front: Double Wishbone Stabilizer Bar\n",
      "Suspension Type - Front: Four C Adaptive\n",
      "Suspension Type - Front: Four Wheel\n",
      "Suspension Type - Front: Fully Independent\n",
      "Suspension Type - Front: Hd Raised\n",
      "Suspension Type - Front: High Performance\n",
      "Suspension Type - Front: Hiper Strut\n",
      "Suspension Type - Front: Horizontal Monotube\n",
      "Suspension Type - Front: Ind. Sla\n",
      "Suspension Type - Front: Independant\n",
      "Suspension Type - Front: Independent\n",
      "Suspension Type - Front: Independent Air\n",
      "Suspension Type - Front: Independent Coil\n",
      "Suspension Type - Front: Independent Coils\n",
      "Suspension Type - Front: Independent Double Wishbone\n",
      "Suspension Type - Front: Independent Macpherson\n",
      "Suspension Type - Front: Independent Sla\n",
      "Suspension Type - Front: Independent Strut\n",
      "Suspension Type - Front: Independent Torsion Bar\n",
      "Suspension Type - Front: Leading Link\n",
      "Suspension Type - Front: Live Axle\n",
      "Suspension Type - Front: Lower Control Arms\n",
      "Suspension Type - Front: M Sport\n",
      "Suspension Type - Front: Macpherson\n",
      "Suspension Type - Front: Magnetic Ride Control\n",
      "Suspension Type - Front: Mcpherson\n",
      "Suspension Type - Front: Mcpherson Strut\n",
      "Suspension Type - Front: Multi Link\n",
      "Suspension Type - Front: Multi Link Double Wishbone\n",
      "Suspension Type - Front: Multi Link Independent Steel Spring\n",
      "Suspension Type - Front: Multi Link Strut\n",
      "Suspension Type - Front: Normal\n",
      "Suspension Type - Front: Normal Duty\n",
      "Suspension Type - Front: Other\n",
      "Suspension Type - Front: Performance\n",
      "Suspension Type - Front: Quadra Link\n",
      "Suspension Type - Front: Radius Arms\n",
      "Suspension Type - Front: Rigid Axle\n",
      "Suspension Type - Front: Short And Long Arm\n",
      "Suspension Type - Front: Single Damping\n",
      "Suspension Type - Front: Single Leaf\n",
      "Suspension Type - Front: Sla\n",
      "Suspension Type - Front: Sla Coils\n",
      "Suspension Type - Front: Sla Coils Torsion Bar\n",
      "Suspension Type - Front: Sla Double Wishbone\n",
      "Suspension Type - Front: Sla Independent\n",
      "Suspension Type - Front: Sla Torsion Bar\n",
      "Suspension Type - Front: Solid Axle\n",
      "Suspension Type - Front: Solid Live Axle\n",
      "Suspension Type - Front: Sport\n",
      "Suspension Type - Front: Sport Tuned\n",
      "Suspension Type - Front: Strut\n",
      "Suspension Type - Front: Toe Control Link\n",
      "Suspension Type - Front: Torsion Bar\n",
      "Suspension Type - Front: Touring\n",
      "Suspension Type - Front: Upper & Lower A Arm\n",
      "Suspension Type - Front: Upper/Lower\n",
      "Air Bag-Frontal-Driver: No\n",
      "Air Bag-Frontal-Driver: Yes\n",
      "Air Bag-Frontal-Passenger: No\n",
      "Air Bag-Frontal-Passenger: Yes\n",
      "Air Bag-Passenger Switch (On/Off): No\n",
      "Air Bag-Passenger Switch (On/Off): Yes\n",
      "Air Bag-Side Body-Front: No\n",
      "Air Bag-Side Body-Front: Yes\n",
      "Air Bag-Side Body-Rear: No\n",
      "Air Bag-Side Body-Rear: Yes\n",
      "Air Bag-Side Head-Front: No\n",
      "Air Bag-Side Head-Front: Yes\n",
      "Air Bag-Side Head-Rear: No\n",
      "Air Bag-Side Head-Rear: Yes\n",
      "Brakes-ABS: No\n",
      "Brakes-ABS: Yes\n",
      "Child Safety Rear Door Locks: No\n",
      "Child Safety Rear Door Locks: Yes\n",
      "Daytime Running Lights: No\n",
      "Daytime Running Lights: Yes\n",
      "Traction Control: No\n",
      "Traction Control: Yes\n",
      "Night Vision: No\n",
      "Night Vision: Yes\n",
      "Rollover Protection Bars: No\n",
      "Rollover Protection Bars: Yes\n",
      "Fog Lamps: No\n",
      "Fog Lamps: Yes\n",
      "Parking Aid: No\n",
      "Parking Aid: Yes\n",
      "Tire Pressure Monitor: No\n",
      "Tire Pressure Monitor: Yes\n",
      "Back-Up Camera: No\n",
      "Back-Up Camera: Yes\n",
      "Stability Control: No\n",
      "Stability Control: Yes\n",
      "Hybrid Engine: 0.0\n",
      "Hybrid Engine: 1.0\n",
      "Engine Configuration: FLAT\n",
      "Engine Configuration: H\n",
      "Engine Configuration: I\n",
      "Engine Configuration: V\n",
      "Engine Configuration: W\n",
      "Tire Rating: H\n",
      "Tire Rating: R\n",
      "Tire Rating: S\n",
      "Tire Rating: T\n",
      "Tire Rating: V\n",
      "Tire Rating: W\n",
      "Tire Rating: Y\n",
      "Tire Rating: Z\n",
      "Country: Germany\n",
      "Country: Italy\n",
      "Country: Japan\n",
      "Country: Korea\n",
      "Country: Sweden\n",
      "Country: UK\n",
      "Country: USA\n",
      "Category: Car\n",
      "Category: Pickup\n",
      "Category: SUV\n",
      "Category: Van\n"
     ]
    }
   ],
   "source": [
    "for i in imputed_data.columns:\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "31237"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(imputed_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "ename": "PermissionError",
     "evalue": "[Errno 13] Permission denied: 'C:/Users/Nicolas/Documents/Scraping/thecarconnection/full_dataset.csv'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mPermissionError\u001b[0m                           Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-35-3dc7f3f72438>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mimputed_data\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mto_csv\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34mr'C:/Users/Nicolas/Documents/Scraping/thecarconnection/full_dataset.csv'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32m~\\Miniconda3\\envs\\tfenv\\lib\\site-packages\\pandas\\core\\generic.py\u001b[0m in \u001b[0;36mto_csv\u001b[1;34m(self, path_or_buf, sep, na_rep, float_format, columns, header, index, index_label, mode, encoding, compression, quoting, quotechar, line_terminator, chunksize, tupleize_cols, date_format, doublequote, escapechar, decimal)\u001b[0m\n\u001b[0;32m   3018\u001b[0m                                  \u001b[0mdoublequote\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mdoublequote\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3019\u001b[0m                                  escapechar=escapechar, decimal=decimal)\n\u001b[1;32m-> 3020\u001b[1;33m         \u001b[0mformatter\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0msave\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   3021\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3022\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mpath_or_buf\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Miniconda3\\envs\\tfenv\\lib\\site-packages\\pandas\\io\\formats\\csvs.py\u001b[0m in \u001b[0;36msave\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    155\u001b[0m             f, handles = _get_handle(self.path_or_buf, self.mode,\n\u001b[0;32m    156\u001b[0m                                      \u001b[0mencoding\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mencoding\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 157\u001b[1;33m                                      compression=self.compression)\n\u001b[0m\u001b[0;32m    158\u001b[0m             \u001b[0mclose\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;32mTrue\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    159\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Miniconda3\\envs\\tfenv\\lib\\site-packages\\pandas\\io\\common.py\u001b[0m in \u001b[0;36m_get_handle\u001b[1;34m(path_or_buf, mode, encoding, compression, memory_map, is_text)\u001b[0m\n\u001b[0;32m    422\u001b[0m         \u001b[1;32melif\u001b[0m \u001b[0mencoding\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    423\u001b[0m             \u001b[1;31m# Python 3 and encoding\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 424\u001b[1;33m             \u001b[0mf\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mopen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mpath_or_buf\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmode\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mencoding\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mencoding\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mnewline\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m\"\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    425\u001b[0m         \u001b[1;32melif\u001b[0m \u001b[0mis_text\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    426\u001b[0m             \u001b[1;31m# Python 3 and no explicit encoding\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mPermissionError\u001b[0m: [Errno 13] Permission denied: 'C:/Users/Nicolas/Documents/Scraping/thecarconnection/full_dataset.csv'"
     ]
    }
   ],
   "source": [
    "imputed_data.to_csv(r'C:/Users/Nicolas/Documents/Scraping/thecarconnection/full_dataset.csv')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
